Kindly clarify, whether here the word RANGE means that CELL VALUE or CELL
RANGES?

TGV

"Arlene" wrote:

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"