Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula assistance required!!! | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
addition to my date formula...required | Excel Worksheet Functions | |||
Rate of return required formula | Excel Worksheet Functions | |||
Price rounding - exception formula required | Excel Worksheet Functions |