|I am trying to create a formula to asist in automatically calculating bonuses according to recorded work performance.|
What I want it to say ( in theory ) is IF C17+D17+E17 are equal or greater than -30(that is a negative thirty) then cell C28 will equal 0 ( no bonus) if they equal less than -30 (say -10) then cell C28 would equal C13+C17+C21+C26.
Basically if they get - 30 points (or more)within three months they will not get a quarterly bonus, if they get less than -30 then they retain their current points minus the deduction in cell C16 included int the C+C+C+C formula.
Am I confusing you yet/ :)
Thank you in advance for your help!