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.
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?