Paul
If ISNA({your formula},{your formula},0)

You've got it backwards. It should be

=IF(ISNA(your formula),0,(your formula))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Paul W Smith" wrote in message
...
Look up the ISNA function

If ISNA({your formula},{your formula},0)

PWS


"ray500"
wrote in message
...

Hi,

I am a newbie to Excel programming and would like to know asap
how to
have on all formulas where I get '#N/A's to the number 0.
The problem
with this is that these N/As are screwing up totals and my
boss would
like to put just 0s. Most of the N/As come from most formulas
dealing
with VLOOKUP such as this formula:
=VLOOKUP(TRIM($B43&$D43),PLUTCommCatPTDyn,8,0)

Can somebody give me the syntax so that when I get a n/a, it
will
default to 0, otherwise let the formula display the legitamate
value is
comes up with. My boss needs this by the end of the day, so
any quick
help is really appreciated. Thanks.


--
ray500
------------------------------------------------------------------------
ray500's Profile:
http://www.excelforum.com/member.php...o&userid=32942
View this thread:
http://www.excelforum.com/showthread...hreadid=527689