Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
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 On Jun 8, 5:26 pm, Amber wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
This worked perfectly, thanks for your help!
"Pete_UK" wrote: 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 On Jun 8, 5:26 pm, Amber wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|