how to display text when a cell>0 ?

  • Thread starter Thread starter Janwillem
  • Start date Start date
J

Janwillem

Hi there.

i have something like this:

A B C D
1 hello 1
2 test 0
3 bye 1


Now i want to display hello at D7 when B1>0

So the output should be:

A B C D
1 hello 1 hello
2 test 0
3 bye 1 bye

How can i do this?

thanks,

Jan Willem
 
Jan, try this, =IF(B1>0,A1,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Jan, works for me, did you put this in D1 or D7 as you said??? should work
in any cell , what error are you getting

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Maybe you typed a letter "O" in the formula instead of a zero?

Paul's formula works fine........just copy and paste it out of his
response......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top