iPad Numbers formula help

Discussion in 'iWork Forum' started by Zera, Feb 18, 2011.

  1. Zera

    Zera
    Expand Collapse
    iPF Noob

    Joined:
    Feb 18, 2011
    Messages:
    3
    Thanks Received:
    0
    I run a business and I want to keep a spreadsheet on my iPad so I have the numbers app. So far I've been really pleased with it. I am used to excel but am by no means an expert in the program so I've noticed numbers is more straight forward and seems easier.

    My problem is this - I need to have a formula that will tell me what percentage I'm paying my credit card company each time I swipe a card.
    Example.

    Cost is $70 CC company charges me 3.5%+ $.15

    $70 is in cell C2

    my formula is C2 X .035 + .15
    OR
    C2 X(.035+.15)

    Formula C2x(.035+.15) works when I have nothing entered into cell C2 but gives me the answer of 12.95 when I have $70 in C2

    Formula C2 x .035+.15 is fine when I have $70 in C2 but shows up as .15 when I have nothing in cell C2.

    I have a feeling this is a simple formula that I am screwing up somewhere, somehow. I appreciate any help that is possible.

    Thanks!
     
  2. dougrogers

    dougrogers
    Expand Collapse
    iPad Fan

    Joined:
    Jan 29, 2011
    Messages:
    152
    Thanks Received:
    10
    Have you tried looking in Apples support discussions for Numbers? If the problem is with your formula, not so much with the iPad.
     
  3. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,749
    You need to use a conditional. You can find the IF command under functions, Categories (tab), Logical and Informational.

    = IF C2, C2 X .035 + .15, 0

    The first part tests if C2 is true or false. True is any value other than 0. The second part is what happens when C2 is true (not 0). The last part is what happens when C2 is 0. You set the answer to zero, since I'm figuring you own nothing if you spend nothing. Each section is separated by a comma.

    Note: A blank cell will also test as false, giving you a zero answer.
     
    #3 twerppoet, Feb 19, 2011
    Last edited: Feb 19, 2011
  4. Frankmezz

    Frankmezz
    Expand Collapse
    iPF Novice

    Joined:
    Oct 31, 2010
    Messages:
    23
    Thanks Received:
    0
    =IF(C2<>0,+C2*0.035+0.15,0)

    I am old school. :)
     
  5. Zera

    Zera
    Expand Collapse
    iPF Noob

    Joined:
    Feb 18, 2011
    Messages:
    3
    Thanks Received:
    0
    Thanks! I need it that way to understand how to put it in. :)
    But I am still getting told I have a syntax error.
     
    #5 Zera, Feb 27, 2011
    Last edited: Feb 28, 2011
  6. pbansen

    pbansen
    Expand Collapse
    iPF Noob

    Joined:
    Aug 13, 2011
    Messages:
    6
    Thanks Received:
    0
    =C2-((C2*.035)+.15) if you want to know what your net is.

    That IS what you want to know, right?
     
  7. Bimjo

    Bimjo
    Expand Collapse
    iPF Novice

    Joined:
    Jun 5, 2011
    Messages:
    79
    Thanks Received:
    2
    (C2*.035)+.15 should tell you the bank's share. pbansen's formula will indeed show you your cut.
     
  8. pbansen

    pbansen
    Expand Collapse
    iPF Noob

    Joined:
    Aug 13, 2011
    Messages:
    6
    Thanks Received:
    0
    Here's the answer, finally!

    Bimjo's formula shows what you're paying the bank in fees expressed in dollars, but to finally address your original question, if you want to know what you are paying in fees expressed as a percentage, the formula would be

    =(((C2*0.035)+0.15)/C2)*100

    For $70, the answer would be 3.71%

    That only took six months - not bad, eh?
     
  9. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,749
    The formula cells can be formatted to display percentages, so that .371 displays as 3.71%. This is advantageous if you want to do any further calculations with the results, since you will not have to first divide by 100.

    All the formulas that do not have a conditional (IF) statement will fail on a zero entry. They either show a false value (.15 or -.15) or will cause an error when dividing by zero.

    Of course you can argue, why would you enter a zero amount to begin with? But the OP did ask for a formula that would not fail on zero, at least by implications.

    I'm sorry I missed the last post. I did not know that the OP was having trouble entering the formula. Since we haven't seen a response I doubt he/she is around to for further help, and has likely solved the problem already.
     
  10. giradman

    giradman
    Expand Collapse
    iPad Monger

    Joined:
    Apr 26, 2011
    Messages:
    5,561
    Thanks Received:
    3,695
    Well, your formulas are not identical, i.e. the first one is correct, but the second one is really C2X(.035 + .15) which is C2X(.185), hence the reason you are obtaining $12.95 rather that the correct answer of $2.60. :eek:
     

Share This Page



Search tags for this page
formula for numbers ipad
,
formulas in numbers for ipad
,
how to use formulas in numbers
,
ipad numbers formulas
,
ipad numbers formulas help
,

ipad numbers help

,
numbers app formulas
,
numbers for ipad help
,
numbers formulas ipad
,
numbers ipad formulas