Hi

Try this in N7

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

Mike

"Shannan" wrote:

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?