P
preyesone
I am trying to combine the IF/And functions:
=IF(SUM(E4+F4+(G4/H4)*0.8)>0.5,0.05,IF(SUM(E4+F4+(G4/H4)*0.8)>0.6,0.1,IF(SUM(E4+F4+(G4/H4)*0.8)>0.8,0.15,AND(J4="Yes",1))))
However it is not recognizing the And portion. No matter what the formula
total is, it should give a 1 if cell J is yes. Can someone help me?
=IF(SUM(E4+F4+(G4/H4)*0.8)>0.5,0.05,IF(SUM(E4+F4+(G4/H4)*0.8)>0.6,0.1,IF(SUM(E4+F4+(G4/H4)*0.8)>0.8,0.15,AND(J4="Yes",1))))
However it is not recognizing the And portion. No matter what the formula
total is, it should give a 1 if cell J is yes. Can someone help me?