Actually I cannot get the formula to recognize anything other than the first
condition...

"preyesone" wrote:

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?