|Subject:||How to make a formula produce a result (and not the "#Value" Error)|
|Posted by:||Mike C (js2k1…@yahoo.com)|
|Date:||Tue, 29 Jul 2008|
Hello - I am trying to build a formula that shows (A1*B1) + (C1*D1).
The problem is that when A1 is empty, the result produces as #Value
Error, even when C1 and D1 have values.
Is there a best way to address this problem? I need the results for
C1 * D1 to show up, even when A1 is blank.
For clarity, the formula I am using is: =AG9*Rates!$B$2+'All current'!
Thanks for any suggestions