Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excel 07 Formula Problem  (Read 2004 times)

0 Members and 1 Guest are viewing this topic.

squall_01

    Topic Starter


    Prodigy

    Thanked: 80
    Excel 07 Formula Problem
    « on: April 02, 2008, 07:28:41 AM »
    I need to figure out the net sales for a bussiness.  I take C which has the sales return an subtract it from the sale amount but I end up getting a negative number an its to supposed to be a positive.  I dont know what I'm doing wrong.  Net sale =C4-B4  thats what I put in.
    Windows 7 RC Tester.  Working on it.  Your monitor says etchasketch on the side!

    If I fall who is there to pick me up now.  I stand alone but I stand as the gaurdian for whom I wish to protect.  The sound of my blade utters my name as you fall.  For I shall not move.  For those that forsake the very people are wosres

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Excel 07 Formula Problem
    « Reply #1 on: April 02, 2008, 08:21:22 AM »
    You haven't gone into enough detail to provide a clear picture of what you're doing in Excel.  But, my impression is that you have the cell references reversed in the formula.  So, try =B4-C4.

    squall_01

      Topic Starter


      Prodigy

      Thanked: 80
      Re: Excel 07 Formula Problem
      « Reply #2 on: April 02, 2008, 09:58:14 AM »
      Thanks I dont now why that book said to do that but its okay.
      Windows 7 RC Tester.  Working on it.  Your monitor says etchasketch on the side!

      If I fall who is there to pick me up now.  I stand alone but I stand as the gaurdian for whom I wish to protect.  The sound of my blade utters my name as you fall.  For I shall not move.  For those that forsake the very people are wosres