The formula below returns the error #VALUE!


The formula is on a separate worksheet, and it is adding up the value of different cells on different worksheets, in the same excel file.


=ROUND(IF(C283=0,0,IF(ABS(C283)<=Purchase!C283,C283*Purchase!D283,IF(ABS(C283)-Purchase!C283<=Beginning!F283,Purchase!E283+(C283-Purchase!C283)*Beginning!G283,"form T/R"))),2)


The cells it is refering to all have formulas in them that relate to other criteria.


If there are values in all the cells the formula will work.


However if one of the reference cells is empty or null value, the error #Value!, seems to occur.


If there is a value of '0' the formula works fine.


How can I correct this?