Hi. I am trying to create a conditional formula so that if I have 0, it
returns 0, if I have a number greater than or equal to 30 to show 30, and
anything in between 0 and 30 it shows said number. How do I do this? Thanks.

Emily,

Assuming your value is in A1, in B1

=IF(A1=30,30,A1)



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=542580

"SteveG" wrote in
message ...

Emily,

Assuming your value is in A1, in B1

=IF(A1=30,30,A1)

.... or =MIN(A1,30)

Emily didn't, of course, specify what she wanted to output if A1 is less
than zero.
--
David Biddulph

Try this:

=IF(formula<=0,0,IF(formula=30,30,formula))

Where "formula" is your original formula.

HTH,
Elkar


"Emily" wrote:

Hi. I am trying to create a conditional formula so that if I have 0, it
returns 0, if I have a number greater than or equal to 30 to show 30, and
anything in between 0 and 30 it shows said number. How do I do this? Thanks.