InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,187.67
(
0.00%
)
US TECH 100
17,585.60
(
-0.15%
)
Dow Jones
39,056.39
(
0.44%
)
Brent Oil
83.62
(
0.07%
)
Bitcoin
61,476.55
(
0.47%
)
Post# of 4688
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (3) Keep Next 10 Report Keyboard Shortcuts
Replies (3) Next 10 Prev Next

Wayne R

Send PM Follow Ignore
Followers 224
Posts 12449
Boards Moderated 18
Alias Born 09/21/2000

Wayne R

Member Level

Re: None

Thursday, 05/24/2007 7:15:41 AM

Thursday, May 24, 2007 7:15:41 AM

Post# of 4688
I'm trying to set up Excel for my taxes. The old sheet I had died with the computer it was on. So this computer, oh joy, has a newer version of excel. The help button is freekin useless. Thank you microsoft for making help so user friendly that it becomes useless.

So, what I want to do is this

IF cell f2 = BUY then H2*-1, else then h2

very simple equation

Anyone out there can give me the correct format for it?



Public Reply Private Reply New Post
Keep Last Read
Replies (3) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (3) 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