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