SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Pastimes : Computer Learning -- Ignore unavailable to you. Want to Upgrade?

To: Gary E who wrote (29930)11/3/2002 5:05:31 PM
From: thecow  Respond to of 110652
 
HG

Wish I could help but mt excel formula knowledge is very limited.



To: Gary E who wrote (29930)11/3/2002 6:53:23 PM
From: XPLAY  Read Replies (1) | Respond to of 110652
 
I've programmed a lot in Excel, and would think that you need a conditional statement something like this "if (address)>0, then (your formula), "(blank) " " , or something like that. I haven't programmed in years so I probably have some of this statement off a bit, but the idea is there. The rest is up to you.

good luck



To: Gary E who wrote (29930)11/4/2002 2:43:41 AM
From: Miner  Respond to of 110652
 
H.G.

See my additional information added to Tom's response regarding solving your first question. Your other two questions will be solved once you trap the initial error.

Here is an excellent (no pun intended) link for answers and examples cpearson.com

regards, john


HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News