Help Required With IF AND Formula
 

Hi - I need to write an IF AND Formula which evaluates 3 values

IF VALUE1<6 and VALUE2<6 and VALUE350 the result is GREEN

I have the formula to evaluate 2 values IF(AND(VALUE1<6,VALUE2<6),"GREEN"
but how do I incorporate the third value in to this?

Many thanks
Ian

Use formula you have like this IF(AND(VALUE1<6,VALUE2<6,VALUE350),"GREEN"

"Ian" wrote in message
...
Hi - I need to write an IF AND Formula which evaluates 3 values

IF VALUE1<6 and VALUE2<6 and VALUE350 the result is GREEN

I have the formula to evaluate 2 values IF(AND(VALUE1<6,VALUE2<6),"GREEN"
but how do I incorporate the third value in to this?

Many thanks
Ian

you can extend value 3 also under <and
=if(and(value1<6,value2<6,value350),one result,second result)

Ian wrote in message
...
Hi - I need to write an IF AND Formula which evaluates 3 values

IF VALUE1<6 and VALUE2<6 and VALUE350 the result is GREEN

I have the formula to evaluate 2 values IF(AND(VALUE1<6,VALUE2<6),"GREEN"
but how do I incorporate the third value in to this?

Many thanks
Ian

Cheers Jim

I think I was expecting the solution to be much more
complicated!

-----Original Message-----
Use formula you have like this IF(AND
(VALUE1<6,VALUE2<6,VALUE350),"GREEN"

"Ian" wrote in message
...
Hi - I need to write an IF AND Formula which evaluates
3 values

IF VALUE1<6 and VALUE2<6 and VALUE350 the result is
GREEN

I have the formula to evaluate 2 values IF(AND
(VALUE1<6,VALUE2<6),"GREEN"
but how do I incorporate the third value in to this?

Many thanks
Ian




.