- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- How to make a formula produce a result (and not the "#Value" Error)

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

- Re: How to make a formula produce a result (and not the "#Value" Error) posted by Pete_UK on Tue, 29 Jul 2008
- Re: How to make a formula produce a result (and not the "#Value" Error) posted by PCLIVE on Tue, 29 Jul 2008
- Re: How to make a formula produce a result (and not the "#Value" Error) posted by Rick Rothstein \(MVP - VB\) on Tue, 29 Jul 2008
- Re: How to make a formula produce a result (and not the "#Value" Error) posted by Niek Otten on Tue, 29 Jul 2008