Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Financial Spreadsheet Help (2007)
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. -- Merodoc ------------------------------------------------------------------------ Merodoc's Profile: http://www.excelforum.com/member.php...o&userid=37608 View this thread: http://www.excelforum.com/showthread...hreadid=572272 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSNStockquote function is not working in Office 2007 beta | Excel Worksheet Functions | |||
How to inport works spreadsheet into excel 2007 | Excel Worksheet Functions | |||
Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
solver related some financial knowledge may be needed | Excel Discussion (Misc queries) |