Allocation of Prize Money

[guitarman]

Hi there everyone Hope you are all well.

I wondered if you could help me out with formula to obtain the prize money for the end of season awards. It consists of two columns Column (K) which will have a number in each cell denoting finish position

Column(L) Will have a monetary value i.e. £500 or £150 or £100

Column---K--- Column---L---

1 £500

2 £250

3 £150 etc etc

I am unsure what formula to use to obtain the required result

Many thanks in advance for your time.

Mick

 

[Luke M]

Where do the prize money amounts come from? Are they alreayd assigned at those levels to go to first place, second, etc? If so, you could do:
=CHOOSE(K2,500,150,100)

 

[guitarman]

Where do the prize money amounts come from? Are they alreayd assigned at those levels to go to first place, second, etc? If so, you could do:
=CHOOSE(K2,500,150,100)

Hi Luke thanks for that I tried it out and it just comes back #Value what I really want is for me to enter a(1) in column K and £500 to come up in column L So am I right thinking I need a formula Like "1" = £500 "2" = £250 etc or something like that
Many thanks
Mike

 

[Luke M]

That's...what I did?

Perhaps you were just seeing the error when cell was blank? If that's an issue, we can add a quick IF check at the beginning. See file.

 

[guitarman]

That's...what I did?

Perhaps you were just seeing the error when cell was blank? If that's an issue, we can add a quick IF check at the beginning. See file.

Luke Top Man
Thats done the trick problem solved many thanks for your time and trouble
have a great day and a brilliant life
Once again Many Thanks
Mike