Monday, March 07, 2011 9:43:51 AM
Not to stir up the pot,. . .
Now that you did stir the pot I want to stir a bit too
You are quite right but I too use this xxx/100 quite often. When I am making up a spread I do not always know beforehand where the % column comes so t is easier to write X*Y/100 than to write X*Y and then go to the Formatting to use the % presentation. . .takes much longer and of you want to change the number-type for the column then you have to change it back again.
Ideally one should "design" a spread beforehand and then you can plan where you put what. . .many amateurs in Excel programming. . .like I am. . . do it the other way around and we save time on one column and lose 3x "the time" at some other place in the spread.
That's how it works for yours truly!
Now that you did stir the pot I want to stir a bit too
You are quite right but I too use this xxx/100 quite often. When I am making up a spread I do not always know beforehand where the % column comes so t is easier to write X*Y/100 than to write X*Y and then go to the Formatting to use the % presentation. . .takes much longer and of you want to change the number-type for the column then you have to change it back again.
Ideally one should "design" a spread beforehand and then you can plan where you put what. . .many amateurs in Excel programming. . .like I am. . . do it the other way around
and we save time on one column and lose 3x "the time" at some other place in the spread. That's how it works for yours truly!
Conrad Winkelman
What is Vortex AIMing? Look for my Vortex Discussion Forum:
http://investorshub.advfn.com/boards/board.asp?board_id=1341
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.
