Hi
I would like help with placing brackets in right place and any other help on the below formula.
Example ....... COL D contains numbers 1-12 and only numbers = 2,3 and 5 are of interest,
IF(OR(AND(D2=2,D2=3,D2=5),E2=1,F2=4,G2=5),99,0)
sample
D2 value = 2 E2 value = 1 F2 value = 4 G2 value = 5 returned value = 99 all conditions fulfilled
D2 value = 1 E2 value = 1 F2 value = 4 G2 value = 5 returned value = 0
D2 value = 2 E2 value = 4 F2 value = 4 G2 value = 5 returned value = 0
D2 value = 3 E2 value = 1 F2 value = 4 G2 value = 5 returned value = 99 all conditions fulfilled
Please help by modifying formula
Thanks
Ian
Works perfectly