Nested IF with multiple calculations

Hi Everyone

New to this Forum.

I need to calculate the following:

I have weights that have certain prices attached to it, i.e. if the weight in C4 is greater than 1000, then I multiply the cell by the cost in B9 but then I still need to work out how much the cost would be i.e. if its 150 kg then I need to multiple the result from my nested if to get the cost for 150 kg.

=IF(C4>1000,$B$9*7.23,IF(C4>500,$B$9*7.54,IF(C4>300,$B$9*7.86,IF(C4>100,$B$9*8.3,$B$9*9.2))))

How do I do this?

Help would be wonderful.

Thanks

Kim

Thanks, but I don't understand. I am so sorry, I don't want to waste your time.


The 150 is not a constant, it could be any kg amount - which would be typed into C4.


I am not very clued up on the AND either.

Your help would be appreciated.

Kim

Thanks Sandy

But that doesn't solve my problem, I got the same result as you.

I need to now calculate what the costs will be if the persons order weighs a certain amount (c4) what will it come to in total i.e. c4 * 1.66 to give total cost. I can't put it into a separate column because after I have this answer I need to then calculate that if it's a minimum of 9 they will pay 9. but it gives me a circular reference.

So, you need result of =CHOOSE(MATCH(C4,{0,101,301,501,1001}),9.2,8.3,7.86,7.54,7.23)*$B$9 multiple by C4?

=CHOOSE(MATCH(C4,{0,101,301,501,1001}),9.2,8.3,7.86,7.54,7.23)*$B$9*C4

or tell me why just 1.66 or it can be variable?

or you need in one cell two results?

Ahh silly me, I have the correct answer now.

Thanks Sandy

You mean this is a correct answer =CHOOSE(MATCH(C4,{0,101,301,501,1001}),9.2,8.3,7.86,7.54,7.23)*$B$9*C4 ?

Yes, it is

Glad to help.
I saw it thanks for rep and don't forget mark thread as solved. Thank you.