iPad Numbers formula help
This is a discussion on iPad Numbers formula help within the iWork Forum forums, part of the iPad App Store category; 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 ...
iPad Numbers formula help
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.
Cost is $70 CC company charges me 3.5%+ $.15
$70 is in cell C2
my formula is 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.
02-18-2011 10:39 PM
Have you tried looking in Apples support discussions for Numbers? If the problem is with your formula, not so much with the iPad.
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.
Last edited by twerppoet; 02-19-2011 at 01:37 AM.
I am old school. :-)
Thanks! I need it that way to understand how to put it in.
But I am still getting told I have a syntax error.
Last edited by Zera; 02-28-2011 at 01:09 AM.
=C2-((C2*.035)+.15) if you want to know what your net is.
That IS what you want to know, right?
(C2*.035)+.15 should tell you the bank's share. pbansen's formula will indeed show you your cut.
Beyond here, there be dragons.
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
Originally Posted by Bimjo
For $70, the answer would be 3.71%
That only took six months - not bad, eh?
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.
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.
Originally Posted by Zera
By BoredFatMan in forum iWork Forum
Last Post: 05-11-2011, 02:19 PM
By Hal05154 in forum iWork Forum
Last Post: 01-23-2011, 04:37 PM
By Gabi in forum Off-Topic
Last Post: 09-21-2010, 03:04 AM
Search tags for this page
formulas in numbers for ipad
how to use formulas in numbers
ipad numbers formulas
ipad numbers help
numbers app formulas
numbers for ipad help
numbers formulas ipad
numbers ipad formulas
Click on a term to search for related topics.