Excel or other Numeric to Text

  MrAnderson 14:24 03 Jan 03
Locked
  MrAnderson 14:24 03 Jan 03

Hi just a quicky

In excel (XP) when a value is added to a nominated cell I want to display a text box in another cell. So for example:

B1 - value entered 100

C1 - box displays "Must do better"

It doesnt matter what value is added - the reply will always be the same.

  cherria 14:30 03 Jan 03

in C1 enter

=if(b1<>"","Here is my text","")

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…