determining non numeric cells when used in iterative calculations
determining non numeric cells when used in iterative calculations
(OP)
In a building cost estimating spreadsheet, I use my final total to calculate some of the cost components. For example, my engineering and permit fees are both a function of my final cost. I set up an iterative calculation so that it closes to my final cost. This works fine until a cell goes out of bounds, causing the cell formula to return a #REF result. I would like to prevent this from happening. Does anyone know of a formula or technique that will help this problem?
RE: determining non numeric cells when used in iterative calculations
Could you please give us an example of the contents, including formulae, in various cells, so that we have some detail to consider?
Thanks,
Brian
RE: determining non numeric cells when used in iterative calculations
RE: determining non numeric cells when used in iterative calculations
clarification is needed: is one of the cells in column G computing =0.07*G148, with G148 containing the summation of cells G1:G148?
moving cells? do not quite understand why cells are being moved. please clarify.
-pmover
RE: determining non numeric cells when used in iterative calculations
Are you using a circular reference?
You can use a circular reference, but why bother? Why not subtotal your line items (i.e. subtotal), calculate your other costs (i.e. engineering) and add together to make a grandtotal, gandtotal = subtotal + engineering.
Seems very straight-forward unless we're missing something.
good luck,
ProjEngKLS