IF AND function
 

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?

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?

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?

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?