View Single Post
  #1   Report Post  
Ian
 
Posts: n/a
Default 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