Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Sign up or Login to participate.
|
|||||||
Download Now:
Excel 2007 Spreadsheet Queries
|
|
Thread Tools | Search this Thread |
|
#1
08-16-2006
|
|||
|
|||
|
Excel 2007 Spreadsheet Queries
I am trying to create a stock portfolio data spreadsheet for Excel 2007, but I am encountering many problems.
Firstly, I am trying to find a formula that will divide the current value of the stock with the initial price. However, I receive a #Value error (or some equivalent) whenever I try to enter =Quotient(G6:G100,F6-F100). Also, can Excel automatically change the color of the text depending on the preceeding value? If I enter in $222 in one cell followed by $232 in the next, can Excel color the numbers red or green depending on higher/lower? More later. (If you need further explaining, feel free to PM me.) I appreciate all help. http://img75.imageshack.us/img75/9139/portvb5.png |
|
 |
| Similar Topics | ||||
| Topic | Replies | Forum | ||
 Microsoft Office Excel 2007- Automatic Subtraction
|
0 | Software Apps | ||
|
Excel 2007 takes too long to open a file
|
1 | Windows OS | ||
|
Really slow excel 2007 on vista
|
6 | Software Apps | ||
|
Synchronize 2003 Share point using 2007 Office Excel
|
0 | Software Apps | ||
|
Need Help w/ shared Excel spreadsheet
|
4 | Software Apps | ||
| Thread Tools | Search this Thread |
|
|
All times are GMT -4. The time now is 04:32 AM.