=IF(AND(LEN(B6)0,LEN(C6)0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

Vaya con Dios,
Chuck, CABGx3




"bluenoser1946"
wrote in message
news:bluenoser1946.1tedia_1123423541.1811@excelfor um-nospam.com...

I am creating a chart for tracking the result of 2 inputs. Here is an
example:
= (B6 * 1.082) - (C6 * 4.15) + 98.42

On my chart 98.42 shows in all the cells of the column even though I
have not entered anything in cells B6 and C6. Is there a way to have a
blank chart until the inputs are entered? :)


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile:
http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=393665