I am treing to show 0 if the sum is less than 1000 instead of a negative Number Can anyone help me?
R Raymond Monk Feb 13, 2005 #1 I am treing to show 0 if the sum is less than 1000 instead of a negative Number Can anyone help me?
K Ken Wright Feb 13, 2005 #2 Whatever your formula currently is that you don't to return anything greater than 0, try =MIN(0,your_formula)
Whatever your formula currently is that you don't to return anything greater than 0, try =MIN(0,your_formula)
R Raymond Monk Feb 28, 2005 #3 Thank you I will try that Ken Wright said: Whatever your formula currently is that you don't to return anything greater than 0, try =MIN(0,your_formula) Click to expand...
Thank you I will try that Ken Wright said: Whatever your formula currently is that you don't to return anything greater than 0, try =MIN(0,your_formula) Click to expand...
