Numbers, Docs 2 Go, Office2 HD, ???

Discussion in 'iPad Apps' started by Cutshot59, Feb 11, 2012.

  1. Cutshot59
    Offline

    Cutshot59 iPF Noob

    Joined:
    Feb 11, 2012
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Alabama
    Ratings:
    +0 / 0
    Is there an app available to handle a formula like:

    =SUM(SMALL(C34:C38,{1,2,3,4}))


    All of the above seem to be unable to do so and I am tired of paying for them and would really like to use my iPad more.

    Thanks,

    SC.
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,239
    Thanks Received:
    1,966
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,193 / 1
    Perhaps if you describe what the formula is supposed to do we could come up with something that works. The SMALL function in Numbers does not take the parameters you are describing.

    It looks like you want SMALL to return the four smallest values in the range C34:C38 and add them up. You could do this easily enough, but not using SMALL that way. It only accepts one rank parameter. The following would probably work.

    =SUM(SMALL(C34,C38,1),SMALL(C34,C38,2),SMALL(C34,C39,3),SMALL(C34,C38,4))

    At any rate, I think the curly brackets are for arrays. Numbers does not support this. I don't know about any of the other apps, but I doubt you'll find a mobile app that supports a function that advanced.
  3. Cutshot59
    Offline

    Cutshot59 iPF Noob

    Joined:
    Feb 11, 2012
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Alabama
    Ratings:
    +0 / 0
    You are correct in that I want it to find the four smallest numbers of the five and then add them together. I tried your formula and it shows #ARG! as an error message. I made a quick edit from "C34,C38,1" to "C34:C38,1" and it worked. Thanks for the help!! Now I just wish I had come here before wasting time and $$$ on apps. Thanks, again!!!
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,239
    Thanks Received:
    1,966
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,193 / 1
    No problem. Glad it you got it working.

    Sorry about the commas. I always end up in trouble when I try typing out the formula instead of just creating it and using a screen shot. In this case all I did was look the SMALL function definition and type how I thought it would work. When I saw the OSX version of Numbers used a colon, I should have double checked, but I was more interested in seeing if it supported arrays (the curly bracket). It doesn't.

    As for money, you may end up not regretting it too much. Each of the apps have their own strengths and weaknesses. You'll likely run into something only one of the other apps will do for you at some point.

Share This Page

Search tags for this page

docs 2 hd contact

,
office 2 hd app, add page number
,
office 2 hd or numbers
,

office2 vs office2 hd