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?
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?
Use IFERROR function to return whatever you like if error occur
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks