Excel - How to?

oli356

oli356

oli356

Soldato
Joined
10 Jan 2010
Posts
5,319
Location
Reading
Afternoon :)

Getting on with some work with Excel, I've forgotten more than I thought I had!:mad:

excell.png



Individual targets met = £100 bonus (Cell O4, Indbonus)
Australia sales over £70,000 (O2, Aussales) = Australia bonus £150 (O3, Ausbonus)

The Australia sale bonus is working fine (F19:F27) The formula being: =IF(D5>=$O$2,"met", "not met")

Though how can I make something so if 'met' it shows +150 (cell O3) The bonus could have course change at a later date. While if not met there's just a 0 as no bonus will be added.

The same situation with the individual target. I19:I27 the targets are taken from the next sheet. With the forumla in J19 being: =IF(H5>=I19,"met", "not met")
I want to do the same for this as with the Australia bonus, though it will need to show +100 (cell O4)

I hope this makes sense :confused:

Any help for the noob will be greatly appreciated! Thanks
 
I don't quite follow.

You want to check if each person has met their 'Australia' target and then add the 'Australia Bonus' to what? Add it to their 'Commision'?

Then do the same for the 'Individual Bonus'?

Hopefully it should be pretty easy to do if you can explain it a bit more clearly.

Ta
 
Currently, I just wanted to display a +£150 if they had met the target and £0 if they hadn't.

Changed the formula anyway so there is no met/not met and just a £0, £150

=IF(D5>=$O$2,$O$3,0)

So all good for now :)

Thanks anyway
 
You must log in or register to reply here.
Back
Top Bottom