Quickoffice formula help!

Discussion in 'iPad Apps' started by Gabriel1, Feb 1, 2012.

  1. Gabriel1

    Gabriel1
    Expand Collapse
    Super Moderator
    Staff Member

    Joined:
    Mar 11, 2011
    Messages:
    17,096
    Thanks Received:
    747
    Hi guys, I'm trying to set up a new spreadsheet and I'm doing something wrong but my brain is just not comprehending it at the moment.

    Here is the problem, in the first image I am calculating a total of one cell minus another cell, this works fine. In the second image I m trying to calculate the previous answer multiplied by another cell......but it isn't working and despite all my efforts I can't get it to work.......your help would be most welcome.

    image-13920750.png



    image-1072198001.png

    The Archangel
     
    #1 Gabriel1, Feb 1, 2012
    Last edited: Feb 1, 2012
  2. psy

    psy
    Expand Collapse
    iPF Novice

    Joined:
    Dec 29, 2011
    Messages:
    37
    Thanks Received:
    1
    I have created spreadsheets with sums using quick office pro, I used brackets so the sum in the bracket was calculated before the next bit.... Your situation sounds more complex but I did find the help files on their web site very help full.
     
  3. hpulmer

    hpulmer
    Expand Collapse
    iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    725
    Thanks Received:
    28
    Gabriel1,
    Nothing wrong with your formulas, it's all about the format!
    See below, I used your formulas and there is no problem - just in the £/miles you put a "." as the decimal separator, I put the "," - do NOT ask me why this is not depending on the country settings in Quickoffice (or it might well be) - I am using the German setting on my iPad.....
     

    Attached Files:

  4. psy

    psy
    Expand Collapse
    iPF Novice

    Joined:
    Dec 29, 2011
    Messages:
    37
    Thanks Received:
    1
    I just recreated your sums in my quick office pro.
    Try removing sum and brackets..... So. You have. =b3-a3. And. =c3*d3

    Give that a go.....worked on mine. :)
     
  5. Gabriel1

    Gabriel1
    Expand Collapse
    Super Moderator
    Staff Member

    Joined:
    Mar 11, 2011
    Messages:
    17,096
    Thanks Received:
    747
    Thanks guys, I really appreciate the help. psy's solution worked so I am a happy bunny again and can keep my mileage updated!

    The Archangel
     
  6. hpulmer

    hpulmer
    Expand Collapse
    iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    725
    Thanks Received:
    28
    Justtrieditout - works fine with sum and brackets, but not with the . instead of the , on my sheet...
     
  7. hpulmer

    hpulmer
    Expand Collapse
    iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    725
    Thanks Received:
    28
    Oops... But not with sum and brackets on a 'product' !
    ;o)
     
  8. Gabriel1

    Gabriel1
    Expand Collapse
    Super Moderator
    Staff Member

    Joined:
    Mar 11, 2011
    Messages:
    17,096
    Thanks Received:
    747
    Maybe I need to change the formatting somewhere but at least it's working. I'll do a copy/paste of the whole sheet and play around with the formatting at the weekend.....not enough time to play during the week at the moment.

    The Archangel
     
  9. psy

    psy
    Expand Collapse
    iPF Novice

    Joined:
    Dec 29, 2011
    Messages:
    37
    Thanks Received:
    1
    Sweet.
     
  10. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,428
    Thanks Received:
    4,274
    A probably unnecessary explanation.

    The SUM function adds up all the cells in a range. You don't put an arithmetic formula inside it; just the first and last cell in a range that you want to be added up. Say you wanted to add up cells A1, A2, and A3. You'd enter SUM(A1,A3) and you'd get the sum of all three cells. {Cell separators may differ from app to app, it might be SUM(A1:A3), I don't remember what Excel's separator was.}

    You just wanted the difference and multiplication of two cells. The only functions you needed were the math operations inbetween, the (-) minus and (*) multiply operations.
     
    #10 twerppoet, Feb 1, 2012
    Last edited: Feb 1, 2012

Share This Page



Search tags for this page

division format in quickoffice spreadsheet

,

formula to subtract in quickoffice excel

,

how do i add and subtract in quickoffice pro

,

how to get sum in excel quickoffice app

,

how to multiply in quickoffice

,

quick office how to plus formula

,

quickoffice formulas

,

quickoffice ipad sum function

,

quickoffice iphone sum

,

quickoffice subtract