In E2, insert =IF(D2="","",D2*C2/B2)

--
HTH

Kassie

Replace xxx with hotmail


"adnil" wrote:

I am trying to make a shopping list in B2 i want to put the weight as in 1kg
or 1000grams in C2 I want to put the price per kilo in D2 I want to put the
amount I need say 500grs or half kilo and then in E2 I want the total price.
I have tried a few formula's that I know but this is just not working can
anyone help with this Please. Thanks