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" wrote in message
ups.com...
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