Display issue

B

bluenoser1946

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? :)
 
D

duane

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
 
B

bluenoser1946

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
 
Top