Try it this way:

=min(a1,1300)

Regards,
Fred.

"Arlene" wrote in message
...
I am looking for a formula for excel, I am having trouble getting the right
calculation.
The answer I am looking for is:
if the range is less than 1300 then the answer is equal to the range, if
the
range is greater than 1300 then the answer is 1300.
=if(range)<,"range",if(range)1300,"1300"