Excel or other Numeric to Text

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

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 2003

in C1 enter

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires