# Excel Formula I can't figure out!

Dell / OPTIPLEX 330
April 14, 2009 at 12:56:49
Specs: Microsoft Windows XP Professional, 1.594 GHz / 1012 MB
 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!

See More: Excel Formula I cant figure out!

#1
April 18, 2009 at 03:26:08
 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.

Report •

#2
April 18, 2009 at 08:08:54
 =IF(SUM(C17:E17)>-30,0,C13+C17+C21+C26)What happened to my quote

Report •

Related Solutions