Help With Exel Funtions

[davidk65]

In a spread sheet, I need to establish how much a club member pays for for their membership. The fees are based on the age of a child. The age bands are:
1) From birth up to and including the age of 10. Fee £5-00
2) From 10 (11) up to 18 years. Fee £20-00.
3) From 18 (19) i.e adult years. Fee £40-00.
I have tried using the "IF" Function but get myself tied up as I need to follow this kind of logic:
If the child is 10 or less then the fee is £5-00. if the child is over 10 but less than 18 the fee is £20-00. If the age exceed 18 the fee is £40-00.
The age of each is entered in the appropriate cells in a column, the fee needs to appear in an adjacent cell.
Can anyone help?
Thank you

[Maydup]

I would have a column of ages and a column of prices. Lets say B is ages and C is prices.

In your result cell type
=IF(B1=

[Maydup]

Sorry, can't seem to type it on my ipad without getting very , very confused.

Needs to be if less than or equal to 10, then C1. If 18 the C2 etc.

Lets hope someone can do it in excel for you and copy and paste.

[soapnumpty]

I posted a similar question recently and i've copied the answer below, but changed it to fit your scenario. in the cell where you want the cost to appear, enter the following =IF(A2>10,5,IF(A2

[soapnumpty]

Aah, it's cut off the end of my answer. I'll try again.

[soapnumpty]

=IF(A2< 10, 5, IF(A2 < 18, 20, IF(A2 < 100, 40, 0)))

Try typing this in the cell where you want the cost to appear. i have assumed A2 is where you are going to type the age. Take all the spaces out though. I've just put these in so hopefully it will print my answer this time.

[Maydup]

Reading the post again soap, does it need to be up to 11 for the first price rather than 10 and 19 for the second?

The only reason I was going to suggest using a cell instead of the process was to allow you to put them up in the future without changing to formula. But i lost the will when I couldn't get the answer to post.

[Maydup]

Process? I meant prices!

[soapnumpty]

Yes you're right Maydup. I've just checked it. Replace the 10 with 11, and 18 with 19 and it should work. Got there in the end!

[New Judge]

Two things to bear in mind with soapy’s formula:

1. Members over 99 years of age will be charged no fee (which may not be a problem!)

2. If you have a fee change you will have to change the values in the formulae. Not a big deal, perhaps, but I would use cell references instead of values. So I would put the fee values in (say) cells Z1, Z2 and Z3. The formula would then become:

=IF(A2

[New Judge]

=IF(A21

[New Judge]

Two things to bear in mind with soapy’s formula:

1. Members over 99 years of age will be charged no fee (which may not be a problem!)

2. If you have a fee change you will have to change the values in the formulae. Not a big deal, perhaps, but I would use cell references instead of values. So I would put the fee values in (say) cells Z1, Z2 and Z3. The formula would then become:

=IF(A21 < 10, $Z$1,IF(A21 < 18,$Z$2,IF(A21 < 100, $Z$3,0)))

Then, if your fees change, all you need to do is change the values in cells Z1, Z2 and Z3.

(I’ve had to put a few spaces in as did soapy - don’t forget to take them out.