Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
Is it possible to display text in charts? | Charts and Charting in Excel | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) |