Welcome to iPadForums.net Guest - Click Here to Register

Quickoffice formula help!

This is a discussion on Quickoffice formula help! within the iPad Apps forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 19
  1. #1
    Super Moderator
    Member #
    37823
    Liked
    748 times
    Join Date
    Mar 2011
    Location
    Cranbrook, Kent, UK
    Posts
    17,132
    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.

    Quickoffice formula help!-image-13920750.png



    Quickoffice formula help!-image-1072198001.png

    The Archangel
    Last edited by Gabriel1; 02-01-2012 at 01:04 PM.

  2. Ads


  3. #2
    psy
    psy is offline
    iPF Novice
    Member #
    143465
    Liked
    1 times
    Join Date
    Dec 2011
    Posts
    37
    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.

  4. #3
    iPad Junkie
    Member #
    93846
    Liked
    31 times
    Join Date
    Aug 2011
    Location
    Germany
    Posts
    730
    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 Thumbnails Attached Thumbnails Quickoffice formula help!-image-2911709115.png  

  5. #4
    psy
    psy is offline
    iPF Novice
    Member #
    143465
    Liked
    1 times
    Join Date
    Dec 2011
    Posts
    37
    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.

  6. #5
    Super Moderator
    Member #
    37823
    Liked
    748 times
    Join Date
    Mar 2011
    Location
    Cranbrook, Kent, UK
    Posts
    17,132
    Quote Originally Posted by hpulmer
    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.....
    Quote Originally Posted by psy
    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.
    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

  7. #6
    iPad Junkie
    Member #
    93846
    Liked
    31 times
    Join Date
    Aug 2011
    Location
    Germany
    Posts
    730
    Quote Originally Posted by psy
    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.
    Justtrieditout - works fine with sum and brackets, but not with the . instead of the , on my sheet...

  8. #7
    iPad Junkie
    Member #
    93846
    Liked
    31 times
    Join Date
    Aug 2011
    Location
    Germany
    Posts
    730
    Quote Originally Posted by hpulmer

    Justtrieditout - works fine with sum and brackets, but not with the . instead of the , on my sheet...
    Oops... But not with sum and brackets on a 'product' !
    ;o)

  9. #8
    Super Moderator
    Member #
    37823
    Liked
    748 times
    Join Date
    Mar 2011
    Location
    Cranbrook, Kent, UK
    Posts
    17,132
    Quote Originally Posted by hpulmer

    Justtrieditout - works fine with sum and brackets, but not with the . instead of the , on my sheet...
    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

  10. #9
    psy
    psy is offline
    iPF Novice
    Member #
    143465
    Liked
    1 times
    Join Date
    Dec 2011
    Posts
    37
    Sweet.

  11. #10
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,432
    Quote Originally Posted by Gabriel1 View Post
    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
    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.
    Last edited by twerppoet; 02-01-2012 at 08:09 PM.


Home | Forum | Active Topics | What's New

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Numbers formula help
    By Abunaixd in forum iWork Forum
    Replies: 16
    Last Post: 03-06-2012, 04:09 PM
  2. iPad Numbers formula help
    By Zera in forum iWork Forum
    Replies: 12
    Last Post: 09-02-2011, 08:49 PM
  3. Help with Numbers formula
    By Jmfocus in forum iWork Forum
    Replies: 30
    Last Post: 08-30-2011, 09:06 PM
  4. Numbers Formula Instructions
    By Hal05154 in forum iWork Forum
    Replies: 3
    Last Post: 01-23-2011, 03:37 PM
  5. Formula One Car Crash Video
    By Gabi in forum Off-Topic
    Replies: 3
    Last Post: 09-21-2010, 02:04 AM

Search tags for this page

formula to subtract in quickoffice excel
,
how calculate in mobile quick office
,
how to get sum in excel quickoffice app
,

how to use sum with quickoffice pro hd for ipad

,
quickoffice ipad sum function
,
quickoffice iphone sum
,
quickoffice subtract
,

quickoffice sumif

Click on a term to search for related topics.