InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
5,708.75
(
-0.93%
)
US TECH 100
19,212.00
(
-1.59%
)
Dow Jones
42,156.97
(
-0.41%
)
Brent Oil
74.58
(
0.21%
)
Bitcoin
61,225.60
(
0.65%
)
Post# of 162
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

MSC290

Send PM Follow Ignore
Followers 20
Posts 1704
Boards Moderated 0
Alias Born 01/02/2003

MSC290

Member Level

Re: Wayne R post# 139

Thursday, 05/24/2007 8:57:12 AM

Thursday, May 24, 2007 8:57:12 AM

Post# of 162
Try this Excel formula to see if it works for you. It worked on a test sheet here using Excel 2000.

=IF(F2="BUY",H2*-1,H2)

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 InvestorsHub

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