The Student Room Group
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>

help with excel

Hey guys
I'm stuck on one part of a question. Basically I've done everything except..
If total sales for the month exceed £10,200 the 1 member of staff is given a 10% bonus of the amount that sales exceeded £10,200.


Now I've used the IF function to show that there are some months when sales dont exceed £10,200, but I have no idea how to add the bonus of 10% for a month where e.g. sales are £10,324

I'm supposed to work out 10% of the extra 224 that month and add it to the salary, using the IF function. I could've done it via simple maths but I need to show it via a function.

Any help appreciated
Reply 1
Avatar for Mr.Messy
Mr.Messy
14
I'm not sure. So I'll give the thread a bump.

In English, the function of =IF is
=IF(Cell number is greater or equal to X,(true) then do this,(false) then do that)
so =IF(A1>=10200,$A2*A1,0)

So basically in this equation, the A1 cell has salary p/ month(say 10324 for instance) and in cell A2, its percentage you want to use, so 10%. Then drag the corner on the box to repeat.
That should work I think
(edited 12 years ago)
Reply 2
Avatar for dkdeath
dkdeath
10
You don't give enough info and your post is ambiguous.

cell with total sale of person = pts
cell with persons salaray = ps

In your formula don't use magic numbers assign things such as percentage of increase to cells
=IF(pts > 10200,(pts -10200)*.10 + ps,ps)
(edited 12 years ago)

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you