Formula to multiply value in one column by amount dependent on value from another column

[kornstalker]

I have a spreadsheet w/ a PRICE column, a CODE column, and a DIFFERENCE column. I'd like to have a formula in the DIFFERENCE column that will multiply the PRICE value, and return a value in the DIFFERENCE column, based off of the value entered in the CODE column. For example...If I were to enter a P in the CODE column, I want the DIFFERENCE formula to return a value that is (PRICE*.18). If I were to enter a G, I want the DIFFERENCE formula to return a value that is (PRICE*.33). If I were to enter an O, I want the DIFFERENCE formula to return a value that is (PRICE*0). Obviously the part for the PRICE*0 could skip the multiplication action and just enter a zero if that's a more efficient way.

I was thinking it could be something like this...

=IF(B2=O,0,IF(B2=G,A2*.33,IF(B2=P,A2*0.18)))

or this...

=IF(B2=O,A2*0,IF(B2=G,A2*.33,IF(B2=P,A2*0.18)))

but...neither seem to work. I had a dummy spreadsheet to attach but not sure how to do that either...

Thanks in advance

[Glenn Kennedy]

Try:

=IF(B2="O",0,IF(B2="G",A2*.33,IF(B2="P",A2*0.18)))

failing that...

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

[kornstalker]

That'll do it...thanks!

[Glenn Kennedy]

Glad to have helped....