X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Hiding Error Values    
post Aug 22 2003, 04:46 AM

Posts: 416
Joined: 16-February 03
From: Devon, UK

It can be very irritating to have error values in your spreadsheet, especially where you have a sum() or similar that then picks up this error.
You can use Iserror() to avoid this. For example:
=VLOOKUP(A1,G1:H20,2,FALSE) will return a #N\A if there is no matching value. This can be trapped out with:
This will give you a blank cell if there is no matching value.
Have fun!
John F
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    27th February 2020 - 12:58 AM