troubleshooting Question

# IF OR AND function asked on
Microsoft ExcelMicrosoft Office
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

Thanks
Ian
aikimark
Get vaccinated; Social distance; Wear a mask
Top Expert 2014
###### Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.