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

--
Don Guillett
SalesAid Software

"Trace" wrote in message
...
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