Working in Excel 2010 and I'm looking for a formula in column P which will autofill when new rows are inserted.
Working with row 10, the basic formula is:
where the Range(K10:P10) is formatted as Numeric, to 2 decimal places.
The formula should return "0.00" if the Range(K10:O10) contains no numeric values.
I have this (overcomplicated) formula from another project, but if I insert rows, then the formula does not fill down into those new rows: