M
Mark S
In using an IF statement the "else" value needs to be a
blank cell.=IF(B2 > 10, 'Nov 03'!F72, "") The values are
being charted on a line graph and when 0 or "" are used
the chart shows them as 0 values. When there is no value
I would like them not to appear on the chart at all. Any
ideas?
blank cell.=IF(B2 > 10, 'Nov 03'!F72, "") The values are
being charted on a line graph and when 0 or "" are used
the chart shows them as 0 values. When there is no value
I would like them not to appear on the chart at all. Any
ideas?