RE: Conditional Formatting

Giganews Newsgroups
Subject: RE: Conditional Formatting
Posted by:  Elkar
Date: Tue, 16 May 2006

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.

Replies

None

In response to

Conditional Formatting posted by Emily on Tue, 16 May 2006