+ Reply to Thread
Results 1 to 7 of 7

iPhone Supported functions and formula

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Arrow iPhone Supported functions and formula

    I have an iPhone application called My Docs To Go, I use it to transfer and synchronize my Laptop excel sheet file to my iPhone.

    Unfortunately the below formula contain unsupported function by my iPhone app.
    =((TEXT(B59,"[h]:mm")-"15:00")*24*1.5+15)*nnn.n
    (nnn.n) is the only variable number the rest of the formula numbers are fixed.

    The supported functions by my iPhone app are listed under the following link:
    http://support.dataviz.com/support.srch?docid=14404

    I need help please in editing my above formula using the supported functions of my app from the given link above and end up with the same formula result I use to have on my laptop excel file in order to us it on my iPhone app.
    Last edited by Khaldon; 04-30-2011 at 10:23 AM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help in Supported functions and formula

    whats in b59?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Need help in Supported functions and formula

    Given we need to remove TEXT perhaps:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Need help in Supported functions and formula

    =IF(A59>3.125,A59-3.125,"") is in b59

  5. #5
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Need help in Supported functions and formula

    Removing TEXT did work thank you, however I need help please combining the two formulas below in one to have the second formula part result applied only IF the time value on cell B59 is more than 15:00, otherwise first formula part to be applied?
    =B59*24*nnn.nn
    =((B59*24-15)*1.5+15)*nnn.nn

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: iPhone Supported functions and formula

    So it seems as though you get 1.5 for hours above and beyond 15, correct ?

    If the above is indeed the case then given you can use MIN & MAX perhaps you could use:

    Please Login or Register  to view this content.
    Without knowing where else B59 is utilised (other than in the above) I confess I would be inclined to modify the function in that cell to :

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: iPhone Supported functions and formula

    Your thought were absolutely right on both cods, about cell B59, I just deleted the N from the second code given by you and it works fine.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1