Formula Help

[cowgirlcooper]

Ok, I am having a problem finding a formula that works for what I am trying to do. So any and help is much appreciated!

I am working on an inventory price sheet for an electrical company. I need to take their classifications (ie: 'c' means charged every 100ft, 'm' means charged every 100ft) and find the per foot charge.

This is how I have it set up:

G3:Price
H3:Quantity Measured by
I1:Unit Price

-> Price is: what they charged
-> Quantity: is either 'C', 'M' or 'E'

I need unit price to take 'C' (per 100) and divide the price OR 'M' (per 1000) and divide the price OR 'E' use the price listed. B1 will have Letters NOT numbers.

Please help. I have tried 'IF' and it cant handle the multiple restrictions I have set. I do have the formulas set up on the side so I can reference to other cells, I just need to know what formula is best for me. I have tried looking it up on here already, but am not sure exactly what I am looking for, so if you have a youtube video that will help or can help me by posting a response I will be extremely grateful.

Thank you SO MUCH!

Cowgirlcooper

 

[cowgirlcooper]

the formula i was trying to use was:

=IF(H3=BN2,BP3,IF(H3=BN3,BQ3)G3)

H3 is Quantity Measured
BN2 is another cell with a C
BP3 is my formula taking the price and dividing it by 100
BN3 is another cell wth a M
BQ3 is my formula taking the price and dividing it by 1000
G3 is the original price (meaning 'E')

But it isnt working. :/

 

[P_Guru]

=IF(B1="C",G3/100,IF(B1="M",G3/1000,G3))

Assuming that B1 is where the letter is (C,M, or E)

 

[cowgirlcooper]

You are AMAZING! Thank you so much for all your help!