Removing #na from excel cell

[murto]

I am using a series of listboxs to create a ration formulation sheet. There is room for 10 ingredients of which I am using 8 at present, my problem is that when a listbox is blank(I backspace the listbox) I get #na in the cell where there is lookup and multiplication formula. I would like to have a 0 value when when the ingredient cell is blank as the these cells are involved in a sum function. Later I will want to run scenario or solver function involving these cells.

Many thanks for any help given,

Murdo file:///C:/DOCUME%7E1/Crombie/LOCALS%7E1/Temp/moz-screenshot.jpg:banghead:

[asingh]

Use the isserror operator to trap the Values..

=IF(ISERROR(a2/a4), "YOUR DEFAULT VALUE", a2/a4)

regards,

asingh

[Aussiebear]

Hi Murdo, #N/A is an error code that normally means that a value is not available. Whilst the error trapping method as suggested by asingh will work, it may be a better suggestion to fix the cause and not go to the effort of putting a bandaid on the wound.

Why do you need to backspace the listbox?

[murto]

Thank you for your assistance.

Many Regards

Murdo

[mdmackillop]

Hi Murdo,
To show a jpg, use Manage Attachments in the Go Advanced section; same as for posting files.