also @ TechSpot: US BitTorrent traffic decline credited to legal alternatives

TechSpot
Collaborate in the cloud with Office, Exchange, SharePoint, and Lync.
Microsoft Office 365. Pay-as-you-go starting at $8/user/month. Begin your free trial now.

Excel 2007 Spreadsheet Queries

Discussion in 'Software Apps' started by Merodoc, Aug 16, 2006.

Thread Status:
Not open for further replies.

  1. Merodoc Newcomer, in training

    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
    Merodoc, Aug 16, 2006
    #1
Thread Status:
Not open for further replies.