#Value! error

[PEAKCAB]

Hi,

I am working on invoice and i am trying to have my invoice calculate the weights on the products that are being sent. I have nearly completed this using a vlookup to find the individual weight but when i then use a formula (=A26*N26) , first being the quantity and the second being the result of the vlookup this if fine, but where there are no items in the cells "A" this then gives the #Value ! error. I have tries to format the cells with 0.00;0;;@ but this makes no difference.

Any help would be greatly appreciated.

Regards,

 

[RoryA]

What do you want to see instead if either cell is blank?

 

[PEAKCAB]

What do you want to see instead if either cell is blank?

Hello RoryA,

I need to see a zero value as i autosum the values to give me a total weight

regards,

 

[RoryA]

Try:

=N(A26)*N(N26)

 

[PEAKCAB]

Try:

=N(A26)*N(N26)

Brilliant....Thanks RoryA

 

[RoryA]

Glad to help!