Help needed guys!

[rickwardyy]

Ok so.. I'm absolutely terrible at doing formulas on excel!

I'm trying to work out what formula I would need to count up commission earned in a month so... When someone has passed 200 leads they earn £50 (as seen below)
[TABLE="width: 128"]
<tbody>[TR]
[TD="align: right"]200[/TD]
[TD="align: right"]£50[/TD]
[/TR]
[TR]
[TD="align: right"]245[/TD]
[TD="align: right"]£100[/TD]
[/TR]
[TR]
[TD="align: right"]290[/TD]
[TD="align: right"]£150[/TD]
[/TR]
[TR]
[TD="align: right"]335[/TD]
[TD="align: right"]£200[/TD]
[/TR]
[TR]
[TD="align: right"]380[/TD]
[TD="align: right"]£250[/TD]
[/TR]
[TR]
[TD="align: right"]425[/TD]
[TD="align: right"]£300[/TD]
[/TR]
[TR]
[TD="align: right"]470[/TD]
[TD="align: right"]£350[/TD]
[/TR]
[TR]
[TD="align: right"]515[/TD]
[TD="align: right"]£400[/TD]
[/TR]
</tbody>[/TABLE]

The leads passed already count up in cell C5 so, how would I have a formula that would count the commission earned?

Thanks in advance!

 

[rickwardyy]

Can anyone help? This should seem easy to most of your guys but an absolute nightmare for me!

 

[rickwardyy]

Anyone?

 

[rickwardyy]

Please?

 

[Stiuart_W]

Ok. So I'm sure somebody will help you but a couple of things:-


1) It's really bad form to bump your thread so soon after posting - you come across as a very needy toddler which is most likely to turn people off


2) You state that when 200 tips have been passed then a comissiom of £50 is earned. However your sheet shows that the comission of £50 is given when 200 tips have NOT passed. - Please clarify the rule for earning £50 commison

3) I didn't really understand your table at all. You'll probably need to review your post and make it clearer

 

[rickwardyy]

So when the cell C5 amounts to 200 I need another cell to have £50 in, then when C5 amounts to 245 the same other cell changes to £100 etc..

200=£50
245=£100
290=£150
335=£200
380=£250
425=£300
470=£350
515=£400

 

[Weazel]

maybe ...

=LOOKUP(C5,{200,50;245,100;290,150;335,200;380,250;425,300;470,350;515,400})

 

[Stiuart_W]

Or

=IF(C5>=A9,B9,IF(C5>=A8,B8,IF(C5>=A7,B7,IF(C5>=A6,B6,IF(C5>=A5,B5,IF(C5>=A4,B4,IF(C5>=A3,B3,IF(C5>=A2,B2,""))))))))