Calculate subscription rates

[Oz007]

Hi first time posting on here

Appreciate any help

I need to calculate subscription rates based on turnover.

for example

Company A Turnover £100,000
Company B Turnover £1,500,000
Company C Turnover £4,500,000

Subscription Rates

Under £1m = £300
Under £2m = £600
Under £5m = £900

So I charge Company A £300 / Company B £600 / Company C £900

How do I create a formula for this in Excel?

 

[gaz_chops]

If your turnover figure is in B1, then enter in C1

=LOOKUP(B1,{0,1000000,2000000},{300,600,900})

 

[Oz007]

If your turnover figure is in B1, then enter in C1

=LOOKUP(B1,{0,1000000,2000000},{300,600,900})

Thank you, works perfectly.

 

[gaz_chops]

You're welcome.