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