If Function

[steve1605]

Hello,
I wanted to add certain amount for the certain range. For example, from $0.1 - $5, add $4, from $6-$20, add $6, from $21-$40, add $8 and so on.

What sort of formula should I use. I am able to increase the price by percentage but not by amount. But I wanted to increase the price by amount.

Please help me.

Thank you in advance.

[daddylonglegs]

With original price in A1 try a formula like

=LOOKUP(A1,{0,6,21},{4,6,8})+A1

[steve1605]

Thanks for your quick response. Seems like I did not describe my situation properly. I have the column where are price range 0.1 to 300. I wanted to add certain amount withe range. For example, from $0.1 to $5, add $4 on original amount. From $6-$20, add $6 on original price. From $21-$40, add $8 in original amount and so on.

I would really appreciate is someone could help me on this issues.

Thank you,

[daddylonglegs]

OK, let me clarify.

If you have $3.20 in A1 you want to add $4 to get $7.20 but if the amount was $10 then you need to add $6 to get $16. Is that right?

You can't actually change the cell values with a formula but you can put the formula I suggested (or an extension of that formula) in an adjacent cell, e.g. in B1 copied down.

If you then want to replace the original column with the new you can copy the new column and use Edit > Paste Special > Values to copy over the old.

Does that help or have I misread your intent?

[steve1605]

Thanks a lot. I really appreciate your help. I worked out perfectly.

Thanks again!