Nested If / And Statement with Conditional Formatting.

  • Thread starter Thread starter clk
  • Start date Start date
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.
 
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)))
Click to expand...

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


Regards
Claus Busch
 
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.
Click to expand...
try this. It also adjusts for the "dreaded space bar"

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