How to make a formula produce a result (and not the "#Value" Error)

Giganews Newsgroups
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'!
AB9*Rates!$B$3

Thanks for any suggestions

Replies