| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to conver #n/a's to 0
Hi, I am a newbie to Excel programming and would like to know asap how t have on all formulas where I get '#N/A's to the number 0. The proble with this is that these N/As are screwing up totals and my boss woul like to put just 0s. Most of the N/As come from most formulas dealin 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 wil default to 0, otherwise let the formula display the legitamate value i comes up with. My boss needs this by the end of the day, so any quic help is really appreciated. Thanks -- ray50 ----------------------------------------------------------------------- ray500's Profile: http://www.excelforum.com/member.php...fo&userid=3294 View this thread: http://www.excelforum.com/showthread.php?threadid=52768 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excell cell there is figure Rs.10545,, how to conver in words | New Users to Excel | |||
| I want to convert to CVS(,) from excel, I can't conver to text ? | Excel Discussion (Misc queries) | |||
| How Can I conver date i.e 18/11/2005 to 18112005.? | Excel Programming | |||
| Conver Numbers to Log 10 | New Users to Excel | |||
| Conver text to number in VBA | Excel Programming | |||
Threaded Mode
