Quote Originally Posted by ConneXionLost View Post
Hi Wynsum,

I don't think you need to combine two IF statements, one seems to do fine with this problem. The false result of your first test E12>I12 would be the true result of your second test, so one IF will do.

Just insert this formula in cell I13:

=IF(E12>I12,I12,E12)+(C13*0.5)
Cheers,
Thanks so much for your help! This works perfectly.
I don't know anything about IF statements or why you put in the series of I12, I12, E12. Would you happen to know of a resource where I can read about why it works?