A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hiding zeroes in Office 2002



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 23rd, 2005, 03:48 PM
external usenet poster
 
Posts: n/a
Default Hiding zeroes in Office 2002

Hi
My mate uses Excel 2002. I've talked him through setting up a few formulae,
one of which is like this:
=IF(A2="",0,VLOOKUP(A2,F:H,2,FALSE))
When A2 is empty, this returns a zero - which, he says, cannot be hidden
with conditional formatting or Tools|Options|View / Zero Values. He has
another formula to multiply this value by a quantity, so he can't return a
"" - it needs to be a number.
I use Office 2000 - and don't have this problem!! Both of the above hide my
zeroes. If anyone can shed any light on this I'd appreciate it!
Cheers.

--
Andy.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2003 / Office XP Shortcut Bar Marc Bressman General Discussions 6 June 26th, 2004 08:42 AM
Product Key for Office XP P.G.Indiana Setup, Installing & Configuration 1 June 7th, 2004 03:22 AM
Error #1321 MOS 2003 Setup Chad Harris Setup, Installing & Configuration 1 June 7th, 2004 12:22 AM
completely delete office2000 jason Setup, Installing & Configuration 1 May 28th, 2004 10:08 AM
Office 2003 and Office 2000/97 coexist on same PC? John General Discussions 3 May 6th, 2004 12:36 PM


All times are GMT +1. The time now is 02:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.