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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac