Conditional Formatting

E

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.
 
E

Elkar

Try this:

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

Where "formula" is your original formula.

HTH,
Elkar
 
D

David Biddulph

SteveG said:
Emily,

Assuming your value is in A1, in B1

=IF(A1>=30,30,A1)
Click to expand...

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

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