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.