formulas
 

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"

formulas
 

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"

formulas
 

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)

--
Biff
Microsoft Excel MVP


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

formulas
 

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"

formulas
 

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

"TGV" wrote:

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"