murto
05-13-2007, 07:20 PM
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:
Many thanks for any help given,
Murdo file:///C:/DOCUME%7E1/Crombie/LOCALS%7E1/Temp/moz-screenshot.jpg:banghead: