Forum Discussion
IF AND OR THEN
I'm working on a commission spreadsheet and having problem with figuring the formula for the Bonus: where L56 is the monthly goal and L57 is total sales. It is a step up bonus plan. I have searched ...
this might be a long way around but it works: =IFS(L56-L57=0,500,L57-L56>=30,3000+100*(L57-L56-30),L57-L56>=25,1750,L57-L56>=20,1500,L57-L56>=15,1250,L57-L56>=10,1000,L57-L56>=5,750,L57-L56>0,500,L57<L56,0)