MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Functions in excel


Posted by Jimmy Juice on September 21, 2001 7:37 AM

Does anyone know how to use an empty cell in a formula? I am making an IF THEN argument and I want to say IF there is an empty cell, THEN fill it in with another cell of my choice.
Any thoughts?


Posted by Paul on September 21, 2001 7:47 AM

=IF(B1,"",C1)

Posted by IML on September 21, 2001 8:03 AM

OR

=IF(NOT(ISBLANK(B1)),"",C1)

will work better if text could be entered into b1.

Good luck

Posted by IML on September 21, 2001 8:06 AM

Re: OR

err,
=IF(ISBLANK(B1),C1,"") should do the trick too.