Help with Formula

[Guest]

I have a graph built that automatically updates based on data that is
entered. One of the columns that is graphed, has a formula of =MIN(cell
#,500), because I wanted it set so that if data entered is above 500, the
graph only charts 500. If the data entered is below 500, then it graphs
whatever the acutal number is. Problem is, sometimes the cell will be blank
(if there is no data to enter), and when this happens then it graphs 500
because of the formula. I would like it to either graph zero, or else not
graph anything. I'm trying to figure out how to change the formula
=MIN(cell#,500) so that when the cell is left blank, it graphs zero or
nothing, and not 500.

Thanks in advance for any help.

 

[Pete_UK]

Try this:

=IF(cell#=0,0,MIN(cell#,500))

You might like to change the second zero to "" if you want the cell
treated as a blank.

Hope this helps.

Pete

 

[Guest]

This worked perfectly, thanks for your help!

Try this:

=IF(cell#=0,0,MIN(cell#,500))

You might like to change the second zero to "" if you want the cell
treated as a blank.

Hope this helps.

Pete