I have the following formula in one column (W) in a big data base. It works fine but when rows
are inserted for subtotals or whatever all the formulas return a #VALUE error wrong data type!
If you select the cell and hit F2 edit and return it corrects itself. I replaced IsFormula with IsNumber
for a test with same results.


=IF(IsFormula(V4),V4*E4,V4*Crew1_Labor_Pct)

Any thoughts?

ThanksTom