Quote:
|
Originally Posted by PC_Arcade
You could do it in one fell swoop though 
=IF((E11*0.00025)+(E12*0.0004)+(E11/52*0.025)+(E12/52*0.04)<500,500,A1) |
I knew that .... but as it looked complicated, I broke it down. The OP didn't seem too sure about formulas.