formulas

[Arlene]

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"

 

[Fred Smith]

Try it this way:

=min(a1,1300)

Regards,
Fred.

 

[T. Valko]

if the range is less than 1300 then...

if the range is greater than 1300 then...

What if the range *is* 1300?

See if this does what you want:

=MIN(A1,1300)

 

[TGV]

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

TGV

 

[Arlene]

=MIN(A1,1300) -this formula worked, thank you.

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

TGV