Nested If / And Statement with Conditional Formatting.

C

clk

I am trying to write a nested if and statement. Basically what I need
is:

If F2 > "" AND N2 is between 0 and 50 then apply a conditional
format. This is the start of the formula I tried but I keep getting
an error.

=IF(F2>"",(AND(N2>0,N2<50)))

Any help is appreciated.
 
C

Claus Busch

Hi,

Am Thu, 23 Jun 2011 08:23:39 -0700 (PDT) schrieb clk:
If F2 > "" AND N2 is between 0 and 50 then apply a conditional
format. This is the start of the formula I tried but I keep getting
an error.

=IF(F2>"",(AND(N2>0,N2<50)))

try this:
=AND(F2<>"",N2>0,N2<50)


Regards
Claus Busch
 
D

Don Guillett

I am trying to write a nested if and statement.  Basically what I need
is:

If F2 > "" AND N2 is between 0 and 50 then apply a conditional
format.  This is the start of the formula I tried but I keep getting
an error.

=IF(F2>"",(AND(N2>0,N2<50)))

Any help is appreciated.
try this. It also adjusts for the "dreaded space bar"

=AND(LEN(TRIM(F2))>0,n2>0,n2<50)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top