If formula?

R

rition

I am not sure if I need an IF formula but I am preparing a spreadsheet
for work and basically it's a sponsorship form and if the person gets
sponsorships of different levels they get a different prize i.e.

Up to £10 - Wallet
£10.01-£20 Bootbag
£20.01-£30 T-shirt

etc up to £60 and I would like to enter the amount in column B and
then then let the computer to enter either the prize in column C.

Can anyone tell me how to do this.

I am totally new to excel.

Thank you

Wendy
 
G

Guest

Hi

One way is to use VLOOKUP. First create a table of information:
10 Wallet
20 Bootbag
30 T-Shirt
40 . . .
This can be on a different sheet (of hidden) if necessary. You can then use
a formula like this:
=VLOOKUP(A1,$B$1:$C$6,2)
presuming your figure is in A1 and your table is in B1:C6.
There is more information on this function here:
http://www.contextures.com/xlFunctions02.html

Hope this helps.
Andy.
 
V

Vass

I am not sure if I need an IF formula but I am preparing a spreadsheet
for work and basically it's a sponsorship form and if the person gets
sponsorships of different levels they get a different prize i.e.

Up to £10 - Wallet
£10.01-£20 Bootbag
£20.01-£30 T-shirt

etc up to £60 and I would like to enter the amount in column B and
then then let the computer to enter either the prize in column C.
Click to expand...

Put this formula in cell C1 and copy down as many as you need
If you need a heading, just remove the first few rows as needed.
This is limited to £ 30, if you put more, it will return "no prize"
just remove the last If statement if any amount over £ 20 wins the T'shirt
Oh, and I have allowed for pence as well as pounds

=+IF(B1=0,"No
Prize",IF(B1<10.01,"Wallet",+IF(B1<20.01,"Bootbag",+IF(B1<30.01,"T-Shirt","No
Prize"))))
 
Top