View Single Post
  #1   Report Post  
Janwillem
 
Posts: n/a
Default 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