Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Excel 2000
Name: stuartdm Date: February 8, 2005 at 04:10:50 Pacific OS: XP sp 2 CPU/Ram: AMD 2.6 / 512
Comment:
I have a problem with errors in EXCEL. I wish to add the result of a number of VLOOKUPs together. However, a number of the records that I look up do not exist ( this is not an error)and give #N/A. I wish to either a) find a function that will add cell values together with #N/A being taken as zero. or b) Find a function that puts a given value (eg. 0) in a cell that contains an error but leaves cells without errors in alone.
I have tried ERROR.TYPE and can use this to replace my errors with zeros, but this replaces my values that are NOT errors with #N/A.
Name: chnos Date: February 8, 2005 at 04:56:21 Pacific
Reply:
Simply test each result first. I mean = if(isnumbur(vlookup...);(vlookup....);0)will bring u either a number, either a "0". So u can add them. Is my explaination explainin something...?
0
Response Number 2
Name: stuartdm Date: February 8, 2005 at 05:33:19 Pacific
Reply:
Thanks! - I was unaware of the ISNUMBER and ISERROR functions. These solve my problem.
Summary: When I click on the Excel shortcut icon, or type EXCEL in the Run dialogue box, the opening Excel screen just flashes on and off, and there is a Windows error sound. No workbook is opened at all and n...
Summary: i can not open ms word 2000. os is xp professional. everything else in ms office 2000 professional seems to work fine. the hour glass just sets there. nothing happens. help!!!!!!!!!!!!!!!!!!!!!!!!...
Summary: In an MS Excel document, I have a PDF link that I have no problem to open anywhere else. But on my computer, when I open that link, it opens Adobe and closes it right away (the document never opens......
0 
