Hi,

I've got the current formula:

='Valuation Summary'!$F$26/(SUM('Component Accounting'!J11:M11))*J11

Which is returning #DIV/0! due to trying to divide by zero, is there a way it will return 0 rather than this?