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; I used to be a whiz on excel formulas but I seem to have had all my prior knowledge drained into my feet.......you are right, ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19
  1. #11
    Super Moderator
    Member #
    37823
    Liked
    748 times
    Join Date
    Mar 2011
    Location
    Cranbrook, Kent, UK
    Posts
    17,132
    I used to be a whiz on excel formulas but I seem to have had all my prior knowledge drained into my feet.......you are right, I didn't need to use the SUM function at all! I need to spend some time re-learning everything that I have forgotten!

    The Archangel

  2. Ads


  3. #12
    iPF Legend
    Member #
    28530
    Liked
    1519 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    I have to sympathize there. These days I often feel I spend more time relearning old skills than acquiring new ones.

    Fortunately, relearning is much easier than starting cold.

  4. #13
    iPF Noob
    Member #
    199892
    Join Date
    May 2012
    Location
    Inverness, Scotland
    Posts
    5
    Hi all,
    I am trying to add up the values in a column in Quick Office Pro. One of the values is a negative number which I don't want to include in the total. In MS Excel I would probably just use SUMIF(A1:A100,>0). This would add up all cells in the range A1 to A100 which are greater than zero. Simple!

    However, I can't find the SUMIF function in Quick Office and although it does have various other functions I can't quite work out which one to use. Each function does give you the format for the formula but not a detailed explanation or even some examples. I have tried browsing Quick Office Help but to no avail.

    Does anyone know how to add up positive numbers ONLY or find a negative number in order to subtract it from the total?
    Any suggestions on how to achieve this or other places to search would be greatly appreciated!

    Och Aye the Noob!

  5. #14
    iPF Noob
    Member #
    199892
    Join Date
    May 2012
    Location
    Inverness, Scotland
    Posts
    5
    I solved my problem by using the IF Function.

    My negative number was being generated by subtracting A1 from A2 when A2 had not had a value entered yet. So my formula in B2 was =A2-A1. Where A1 had a value of 125 and A2 was empty the value in B2 was -125.

    I used the IF function to check if the value of A2 was empty or equal to zero and if so make B2 equal to zero otherwise carry out the subtraction as normal. So the new formula in B2 is now =IF(A2=0,0,A2-A1).

    Now if I use the SUM function in Column B the answer is a positive value!

    Simple stuff really but much easier if you can use the SUMIF Function to ignore negative numbers.

    Oh Aye the Noob!!!!!

  6. #15
    iPF Noob
    Member #
    218109
    Join Date
    Jun 2012
    Location
    UK
    Posts
    5
    I reckon you should enter thus: =Your previous answer * the other cell. Example: =C3*D3

  7. #16
    iPF Noob
    Member #
    199892
    Join Date
    May 2012
    Location
    Inverness, Scotland
    Posts
    5
    Hi borryman,
    Thanks for your suggestion.

    If I multiply the previous cell by the next cell (which is empty) I do get a zero which solves the problem with negative numbers but as soon as I input my new value into the next empty cell it multiplies it with the previous cell and doesn't give me the answer I am looking for.

    I want to subtract the previous cell from the newly input cell and show the difference in the next column. Then I want to total the "difference" column.

    I can't see how multiplying can work in this situation.

    Thanks

    AyePad

  8. #17
    iPF Legend
    Member #
    28530
    Liked
    1519 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    You should use an IFELSE statements. I don't use QuickOffice, so I can't offer specific instuctions; but it should go something like this.

    IFELSE (x-y < 0) then y-x, else x-y

    It tests to set if your result (x-y) is negative (less than zero). If it is, then it reverses the equation (y-x) so that you get a positive difference. If it is not less than zero you get the result of x-y, which will be positive or zero.

  9. #18
    iPF Noob
    Member #
    199892
    Join Date
    May 2012
    Location
    Inverness, Scotland
    Posts
    5
    Hi twerppoet,

    QuickOffice seems to have a preset list of Functions. I can't find "IFELSE" on the list but "IF" is so if I drop the "ELSE" and use your statement it works fine. I've tried manually typing in various statements but they always result in a "Function Not Recognised" message appearing. If it's not on their list it just won't work.

    Thanks for your help.

    AyePad

  10. #19
    iPF Legend
    Member #
    28530
    Liked
    1519 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    I must have been operating off of my often faulty memory. Number doesn't have an IFELSE statement either. It just has the IF statement which includes an optional else clause. Sorry for the confusion. Other than that the explanation of how to use it is the same.

    By the way, the Numbers expression does not look like that either. The example I used was meant to be readable, not usable. The Numbers example would look more like this.

    Quickoffice formula help!-numberifexample.jpg

    You can't just type in formulas in iOS Numbers, so a text representation can be misleading. Always read and use the example formats in the app you are using.

    Again, I did not mean to confuse the issue, the opposite actually.


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

division format in quickoffice spreadsheet
,
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 iphone sum
,
quickoffice subtract
,

quickoffice sumif

Click on a term to search for related topics.