Simple Excel formula help, please.

Discussion in 'Bulletin Board ARCHIVE' started by Red Rag, Oct 7, 2005.

  1. Red

    Red Rag Active Member

    Joined:
    Jul 23, 2005
    Messages:
    5,449
    Likes Received:
    5
    Trophy Points:
    38
    Home Page:
    Style:
    Barnsley (full width)
    It's ages since I used excel and I've forgotten how to do it.</p>

    I've been trying to set up the simplest of formulas, where I want column c to equal column a + 25% , less column b.</p>

    I would have thought that the formula I need for column 3 would be something like;</p>

    =sum(a3+25%)-b3</p>

    or</p>

    =a3+25%-b3</p>

    I'm doing summat wrong. Anybody help? Ta.</p>
     
    Red Rag, Oct 7, 2005
    #1
  2. Ome

    Omen Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    7,600
    Likes Received:
    1,113
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    wat about =(a3+25%)-b3
     
    Omen, Oct 7, 2005
    #2
  3. Red

    Red Rag Active Member

    Joined:
    Jul 23, 2005
    Messages:
    5,449
    Likes Received:
    5
    Trophy Points:
    38
    Home Page:
    Style:
    Barnsley (full width)
    Nope

    That doesn't seem to work either.[​IMG]
     
    Red Rag, Oct 7, 2005
    #3
  4. driver

    driver New Member

    Joined:
    Jul 20, 2005
    Messages:
    1,844
    Likes Received:
    0
    Trophy Points:
    0
    Home Page:
    how about

    <font size="2"><span class="smalltext">(a3*1.25)-b3</span></font></p>
     
    driver, Oct 7, 2005
    #4
  5. Gue

    Guest Guest

    =(a3*1.25)-b3
     
    Guest, Oct 7, 2005
    #5
  6. Shy Talk

    Shy Talk Well-Known Member

    Joined:
    Jul 30, 2005
    Messages:
    8,169
    Likes Received:
    5,036
    Trophy Points:
    113
    Location:
    Tarn
    Home Page:
    Style:
    Barnsley (full width)
    =(A3*125%)-B3
     
    Shy Talk, Oct 7, 2005
    #6
  7. Gue

    Guest Guest

    RE: =(A3*125%)-B3

    =A1*1.25-B1
     
    Guest, Oct 7, 2005
    #7
  8. Gue

    Guest Guest

    Formula

    So assuming you have 100 in box a1 and 50 in b1 and you want c1 to equal a1+25%-b1=75 (125-50) the formula you would enter would be:

    =a1/100*125-b1. (use the forward slash key in lower case and the asterisk which is on upper case (9th key from right top row)
     
    Guest, Oct 7, 2005
    #8

Share This Page