formulas

A

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"
 
T

T. Valko

if the range is less than 1300 then...
if the range is greater than 1300 then...
Click to expand...

What if the range *is* 1300?

See if this does what you want:

=MIN(A1,1300)
 
Top