if function that returns and multiplies

hi there,

i am using excel to log welding on site and am tracking various types of welds and their prices. I have 8 columns: 4 types of welds and another 4 for their individual prices. I want excel to return a price to me when i enter the size of the weld in the type column. So far I am using the IF function like this

=IF(BF10,475.51,"")

So whenever I write that for example a 12" weld has been completed it returns the price 475.51. However this is the price per inch so I need the formula to know that it is to multiply by 12 without me having to change the formula according to the size of the weld.

Really hope someone can help or has an idea.

Thanks!

Is this not just a simple case of multiplying the number in cell BF10 by 12?

So would you just not need:
=IF(BF10="","",(475.51*BF10))

I can't see what else you need really.
It looks like you just want to apply a price of 475.51 per inch sold? Correct me if I'm wrong

Is this not just a simple case of multiplying the number in cell BF10 by 475.51? 'Cus what would be written in cell BF10 is the length (in inches)

So would you just not need:
=IF(BF10="","",(475.51*BF10))

I can't see what else you need really.
It looks like you just want to apply a price of 475.51 per inch sold? Correct me if I'm wrong