InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,064.20
(
0.91%
)
US TECH 100
17,076.00
(
0.00%
)
Dow Jones
38,225.66
(
0.85%
)
Brent Oil
83.98
(
0.42%
)
Bitcoin
59,394.85
(
0.46%
)
Post# of 47075
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

AIMster

Send PM Follow Ignore
Followers 2
Posts 1949
Boards Moderated 0
Alias Born 08/04/2003

AIMster

Re: Conrad post# 34128

Monday, 03/07/2011 4:34:30 PM

Monday, March 07, 2011 4:34:30 PM

Post# of 47075
RandyH
=IF(LEN(B29)>0,J29*D29/100,"")
Is not accepted in Excel for Office 2000!

Does it give you a particular error message? I did a quick google of looking for a blank cell in Excel 2000 and the test you cite is supposed to be good for versions from 97 through 07 at least.

The one page I looked at mentioned a function called ISBLANK. So if you set that one up:

=IF(ISBLANK(B29),"",(J29*D29)/100))

see if that will work for you.

Best,

AIMster

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up