Nested If / And Statement with Conditional Formatting.

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

 

[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

 

[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)