how to display text when a cell>0 ?

[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

 

[Paul B]

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

 

[Janwillem]

yes i already tried that, but i get the error that the function is
incorrect.

 

[Paul B]

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

 

[CLR]

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