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!

Report •

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 •

April 18, 2009 at 08:08:54

What happened to my quote

Report •

Related Solutions

Ask Question