| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assign #N/A to blank?
Hello,
I have some cells with Vlookup formula that return #N/A value. How can I tell it to show blank when it returns #N/A? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
assign #N/A to blank?
Like this:
=IF(ISNA(your_formula),"",your_formula) i.e. if your formula returns #N/A then return a blank, otherwise return what your formula returns. Hope this helps. Pete On Aug 19, 4:06*pm, Cam wrote: Hello, I have some cells with Vlookup formula that return #N/A value. How can I tell it to show blank when it returns #N/A? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Assign blank cells in a column with a value of 1 for sum purposes | Excel Discussion (Misc queries) | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
Linear Mode
