IF AND function

[Joy]

Hi,

I'm trying to do and if then formula, but I need two "if" conditions...
something like =if(condition,and(additional condition), result if true,
result if false). I can't get it to work. Any suggestions?

 

[Max]

Try something along these lines ..:

In say, C1: =IF(AND(A1>10,B1<50),30,"")

 

[Joy]

This didn't work - anymore suggestions?

Try something along these lines ..:

In say, C1: =IF(AND(A1>10,B1<50),30,"")

 

[JulieD]

Hi

then you'll need to be more specific about what you want as Max's answer
shows the correct syntax for testing of two conditions in an if statement.
so
-what are the actual conditions
-what are the actual cell references
-what are the actual true and false statements

Cheers
JulieD