Conditional Formatting

[Emily]

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.

[SteveG]

Emily,

Assuming your value is in A1, in B1

=IF(A1>=30,30,A1)



HTH

Steve

[Elkar]

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.

[David Biddulph]

"SteveG" <[email protected]> wrote in
message news:[email protected]...
>
> 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