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.
