Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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.

Re: Blank Cell as result of formula

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

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

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

Ignore First reply

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

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

Re: Blank Cell as result of 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

=====

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.