Excel Formulas "Not Greater than"

T

Trace

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
 
E

Elkar

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
 
T

Trace

Fantastic. THANKS!

Elkar said:
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
Click to expand...
 
Top