+ Reply to Thread
Results 1 to 2 of 2

Parse Error - Google Drive Spreadsheet

  1. #1
    Registered User
    Join Date
    05-04-2006
    Posts
    39

    Parse Error - Google Drive Spreadsheet

    Hello,

    So I am manually keeping records for my small business and am wanting to create a formula that can reduce the payments I receive accordingly by the transaction fee's

    So if I use Square card reader, they take 2.75%. My F column is bound to a drop down list of Square,Wave,No. I will use this to track if I used a service that has a fee. A column is the Fee for my services.

    Here is the formula I came up with and I am getting the Parse Error on

    =IF(F4='Wave',A4*.971-.30,IF(F4='Square',A4*.975, A4))

    I also tried

    =IF(F4='Wave',(A4*.971-.30),IF(F4='Square',(A4*.975), A4))

    If they paid with Wave I get charged 2.9% + .30 cent transaction fee
    If they paid with Square its 2.75%
    If its no, I just want the fee to remain

    I could be way off base, but the reference I am using for my formula is from here

    http://spreadsheets.about.com/od/oth...f-function.htm
    = IF ( A1 < 26 , 100 , 200 )
    Last edited by mglassco; 03-22-2013 at 03:52 PM.

  2. #2
    Registered User
    Join Date
    05-04-2006
    Posts
    39

    Re: Parse Error - Google Drive Spreadsheet

    well I guess google doesn't like single quotes ' must be "

+ 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