how to display text when a cell>0 ?
 

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 B10

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(B10,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" wrote in message
. ..
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 B10

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

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


"Paul B" wrote in message
...
Jan, try this, =IF(B10,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" wrote in message
. ..
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 B10

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, 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

"Janwillem" wrote in message
...
yes i already tried that, but i get the error that the function is
incorrect.


"Paul B" wrote in message
...
Jan, try this, =IF(B10,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" wrote in message
. ..
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 B10

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

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



"Janwillem" wrote in message
...
yes i already tried that, but i get the error that the function is
incorrect.


"Paul B" wrote in message
...
Jan, try this, =IF(B10,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" wrote in message
. ..
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 B10

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