Thread: Help!!!
View Single Post
  #2   Report Post  
GerryK
 
Posts: n/a
Default

Work on this logic:
=IF(AND(A34,A84,A124),3,"")

HF
-----Original Message-----
I'm new to functions and formulas in Excel. I need to

write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the result

is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1

through 12 is 1


.