Excel Formulas "Not Greater than"

[Guest]

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

 

[Don Guillett]

Have a look in the help index for MAX and MIN.

 

[Guest]

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

 

[Guest]

Fantastic. THANKS!

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