Need help with IF statements!?!

[JBulmer]

Hi,

I'm trying to create a spreadsheet and need help with IF Statements. I've got 3 numbers (£1,£5 and £10) and they're my set figures but I have them set as Units so 1 Unit = £1, 2 Units = £5, 3 Units = £10. So, I need to create an if statement to say if Unit Staked is 1 in the next column it says £1 and be able to change the unit staked to the 3 different numbers. See the picture below for a better understanding.

 

Thanks,  Jack

[#2 · Accepted solution]

Try this:

=INDEX($B$2:$B$4, H5)

[#3]

@Savia Just needed to change the B4 to D2 (=INDEX($B$2:$D$2, H5) but it worked perfectly thank you for a quick response! :)

[#4]

Oops, yes, typo. Glad this worked out!