Function Help

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,

I want a cell to return the value of another cell, unless
that value is greater than 20, I want it to be 20, or if
that value is less than -5, then I want it to be -5.

I can do one or the other [ie. =IF(H3>20,20,H3)], I do not
know how to nest both arguments.
Thanks in advance for your help,

Steve
 
You guys are the best, I don't know what else I would do,
I sit here and struggle, the boss has got a deadline, I
try help etc., but as a last resort I come here when
things are down to the wire, and I get accurate and
friendly help.

Thanks!
-----Original Message-----
=IF(H3>20,20,IF(H3<-5,-5,H3))

--

Regards,

Peo Sjoblom


Steve said:
Hi,

I want a cell to return the value of another cell, unless
that value is greater than 20, I want it to be 20, or if
that value is less than -5, then I want it to be -5.

I can do one or the other [ie. =IF(H3>20,20,H3)], I do not
know how to nest both arguments.
Thanks in advance for your help,

Steve
Click to expand...


.
Click to expand...
 
Steve said:
Hi,

I want a cell to return the value of another cell, unless
that value is greater than 20, I want it to be 20, or if
that value is less than -5, then I want it to be -5.

I can do one or the other [ie. =IF(H3>20,20,H3)], I do not
know how to nest both arguments.
Thanks in advance for your help,

Steve
Click to expand...

if you type in I3: 20 in J3: -5
the formulas:
=LARGE(H3:J3,2)
help you..
..i
 
Back
Top