Søren Neigaard wrote:
Hello
I have a spreadsheet where I have some cells that subtract two other
cells, and this means that for some of the cells still not containing
data, the result will be negative. I then have a graph displaying the
calculated data, and the problem with this is that this graph then
shows huge negative values, and this confuses a lot. I would like it
to simply show zero for any values that are zero or below zero. Can
this be done, and how?
Best regards
Søren
Yes, this is fairly simple, if I understand your situation correctly.
Let's say the column that gives the result that you're interested in
plotting is column C (C2 for this example). Set up the following formula
in D2:
=IF(C2<0;0;C2)
This way, if C2 is negative, the number displayed in D2 will be zero. If
C2 is positive, the number displayed in D2 will be the number in C2.
Then use column D for plotting, which will avoid having any negative
values plotted.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
