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


"Joy" wrote in message
...
This didn't work - anymore suggestions?

"Max" wrote:

Try something along these lines ..:

In say, C1: =IF(AND(A110,B1<50),30,"")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Joy" wrote in message
...
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?