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?