| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove #N/A Error
I am creating a spreadsheet where a user can select different categories
which then populate adjacent cells with information from a second hidden sheet. Right now I am using this formula and want to remove the #N/A error that appears when no category has been chosen: =IF(ISBLANK((VLOOKUP(D11,mmtable,3,FALSE))),((VLOO KUP(D11,mmtable,2,FALSE)))*E11,((VLOOKUP(D11,mmtab le,3,FALSE))*E11)+(VLOOKUP(D11,mmtable,2,FALSE))) I have seen solutions for this along the lines of =IF(ISNA(formula),""(formula)) but I do not think this will work for me since I need to keep the both the "if true" and "if false" parts of mine. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| How to remove red strikethrough generated as an error? | Excel Discussion (Misc queries) | |||
| =IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error | Excel Worksheet Functions | |||
| Excel error - remove some formatting | Excel Discussion (Misc queries) | |||
| Remove #DIV/0! error | Excel Discussion (Misc queries) | |||
Threaded Mode
