Formulas

[Shannan]

Hi,
I want to make cell N7 show the text that is written in cell D5, but if
there isn't anything written in D5 yet, then i want N7 to remain blank. What
formula can i use?

 

[Mike H]

Hi

Try this in N7

=IF(D5<>"",D5,"")

Mike

 

[KC]

=IF(D5=0, "",D5)

or

=IF(D5<>"", D5,"")

-kc
*Click YES if this helps

 

[Niek Otten]

In N7:

=IF(D5="","",D5)