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

=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

how about

= (B6 * 1.082)*IF(ISBLANK(C6),0,1) - (C6 * 4.15)*IF(ISBLANK(B6),0,1) +
98.42*IF(AND(NOT(ISBLANK(B6)), NOT(ISBLANK(C6))),1,0)

the chart will then display all zeros until both b6 and c6 have entries


--
duane


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

Thanks Duane. I tried to figure out what you did and apply it to
=(E5/B5)*100 which show up as #DIV/0! on my chart but to no success.

This is the last fault on my chart.

Pete

old dog trying to learn new tricks


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

Thanks CLR as well :)


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

=
"bluenoser1946"
wrote in message
news:bluenoser1946.1telue_1123434370.9543@excelfor um-nospam.com...

Thanks CLR as well :)


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