MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Blank Cell as result of formula


Posted by Alain Herbertz on October 12, 2001 5:02 AM

Hi,
I am using two cells : one cell with a value, the second cell containing a formula using the value in the first cell.
What i would like is :
- when the first cell contains a value, the second cell contains the results of the formula
- when the first cell is BLANK, the second cell should also be BLANK.
Regards. Alain.


Posted by lenze on October 12, 2001 5:23 AM

Posted by Eric on October 12, 2001 5:25 AM

=if(isblank(a2),"",formula results) hope that helps (NT)

Posted by lenze on October 12, 2001 5:26 AM

Ignore First reply

Use the ISBLANK Function
In 2ndcell enter =IF(ISBLANK(1stCell),"",Formula)

Posted by Aladin Akyurek on October 12, 2001 7:27 AM

Another method would be:

=IF(LEN(the-first-cell),the-computation-that-refers-to-the-first-cell,"")

Aladin

=====