Calculator in Excel.

Hi Guys,

I built a calculator in Excel that does the following,

- VLOOKUP an amount from a pricing grid (For 4 different cells)
- Then takes the appropriate value from the pricing grid and multiplies
it by its corresponding cell value. (For all 4 cells)

The problem I am having is, if I don't add a value in one of the cells
I get a #N/A in my Total cell. Is there a quick solution without VBA so
that it doesn't have to have values in each, to compute the total?

I hope someone understands what I am saying. :s Cuz I sometimes don't
hehehe...

Alen.

Possibly something along this line:
=if(iserror(vlookup formula),0,vlookup formula)

--
Regards,
Tom Ogilvy



"Alen David" <[email protected]> wrote in message
news:[email protected]...
> Hi Guys,
>
> I built a calculator in Excel that does the following,
>
> - VLOOKUP an amount from a pricing grid (For 4 different cells)
> - Then takes the appropriate value from the pricing grid and multiplies
> it by its corresponding cell value. (For all 4 cells)
>
> The problem I am having is, if I don't add a value in one of the cells
> I get a #N/A in my Total cell. Is there a quick solution without VBA so
> that it doesn't have to have values in each, to compute the total?
>
> I hope someone understands what I am saying. :s Cuz I sometimes don't
> hehehe...
>
> Alen.
>

Thanks Tom!

That worked!

Alen