Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not showing #N/A
Hi
Is there a way to set the excel column so it does not display the #N/A I have a spreadsheet with a V-look up ready to calculate when the user enters the details but until this happens it comes up with a little green triangle and a #N/A - where I want it to remain blank Any suggestions greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not showing #N/A
Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rexmann" wrote: Is there a way to set the excel column so it does not display the #N/A I have a spreadsheet with a V-look up ready to calculate when the user enters the details but until this happens it comes up with a little green triangle and a #N/A - where I want it to remain blank Any suggestions greatly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not showing #N/A
Hi Max
Job done, thank you Cheers Rexmann "Max" wrote: Just trap it with an IF(ISNA(...) construct, indicatively like this: =IF(ISNA(vlookup(...)),"",vlookup(...)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rexmann" wrote: Is there a way to set the excel column so it does not display the #N/A I have a spreadsheet with a V-look up ready to calculate when the user enters the details but until this happens it comes up with a little green triangle and a #N/A - where I want it to remain blank Any suggestions greatly appreciated |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not showing #N/A
An alternative is to use Conditional Formatting to change the font colour to
white (or the background colour) if the cell satisfies the ISNA() condition. -- David Biddulph "Max" wrote in message ... Just trap it with an IF(ISNA(...) construct, indicatively like this: =IF(ISNA(vlookup(...)),"",vlookup(...)) "rexmann" wrote: Is there a way to set the excel column so it does not display the #N/A I have a spreadsheet with a V-look up ready to calculate when the user enters the details but until this happens it comes up with a little green triangle and a #N/A - where I want it to remain blank Any suggestions greatly appreciated |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not showing #N/A
Welcome, Rexmann
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rexmann" wrote in message ... Hi Max Job done, thank you Cheers Rexmann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
Showing #VALUE! | Excel Worksheet Functions | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
showing a zero | New Users to Excel | |||
why there isn't anything showing up? | Excel Discussion (Misc queries) |