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!

Im not an expert on excel formula's. But i usually find on a long formula it is easier to split it across serveral cells. Once it finally works, you can either leave it. Or try to join it all back into one cell.

Just a thought.

=IF(SUM(C17:E17)>-30,0,C13+C17+C21+C26) What happened to my quote

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History