Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Seek assistance in the formula for IF C9=10 and A9=2 or"2D" or "3S"
should return B9 else "0000" I wrote as =IF(AND(A9=2,C9=10),B9,IF(AND(A9="2D",C9=10),B9,IF (AND(A9="3S",C9=10,B9))). I get the correct number if the conditions comply, else a "FALSE". I am unable correct my formula to incorporate "0000" Thank you. -- Robert |