Excel Formulas "Not Greater than"
This should work for you:
=MIN(2006!A15-15,5)
Note, you don't need to use the SUM function if you're only referring to a
single cell.
HTH,
Elkar
"Trace" wrote:
I want to create a formula that does the following
1) Takes a number from another worksheet
2) Subtracts a certain number from it
3) Gives a value that is not great than another number
Example
=sum(2006!A28)
Less 15
Not greater than 5
Or
23-15=8 not greater than 5 = 5
|