This is the formula:

=IF(OR(LINTEL="PC",LINTEL="OP"),((SUM((LENGTH+0.66 67)*HEIGHT)+(HEIGHT*0.667))*FACTOR*EA*QTY)-Precast/(VLOOKUP(TYPE,ProductData,3,FALSE)*2)-BBEAMS+(HALF*0.5),((SUM((LENGTH*HEIGHT*QTY*EA)*FAC TOR)-(HALF*0.5)-BBEAMS-CORNERS)))

The formula works in all the rows above. It just quit working in all added
rows. When I click on "Add Item", it copies the formula down and it is
exactly as the rest, but it doesn't work. The cell is blank. No error
message, nothing. And the formula is there. I can copy all data from a row
above and paste it in the row below and still blank. I'm stumped.

"Francis" wrote:

What's the error shown? How has its stopped working?
post your formula so that we can evaluate it
in order to solve it.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Edward" wrote:

My formulas in excel 2007 stopped working. I use this sheet everday at work
and need it fixed asap. Anybody have a solution? I checked excel options to
make sure the calculations was set a automatic.