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
=====
