R1C1 Forumla in VBA returning Application-defined error 1004

[dsrt16]

When a user selects "Reedsy/Stripe," I need the cell in row E to give the results of this formula. (The number in the row above *.10) + (((The number in the row above + (the number in the row above *.10)) * 0.029 + 0.030).

This is because the Reedsy fee is 10 percent of their earnings listed in the row above. Then the stripe fee is 0.029 percent + 0.30 cents of their earnings * 10 percent. So if they earned $100. The stripe fees are based on them earning $110.

However, when a user selects "Reedsy/Stripe," instead of getting the answer in column E in a negative since it is an expense, it gives an application-defined error.


Here is the vba code where Sheet1.Range("N48")= Reedsy/Stripe. Setup Page R48C17 = 10 percent. Setup Page R44C17 = 0.029 and Setup PAge R44C19 = 0.30.

Why am I getting an error?

ElseIf c1.Value = Sheet1.Range("N48") Then
            Cells(c1.Row, "E").FormulaR1C1 = _
              "=-(R[-1]C*'Setup Page'!R48C17)+(((R[-1]C+(R[-1]C*'Setup Page'!R48C17))*'Setup Page'!R44C17+Setup Page'!R44C19)"

I feel like I have all the parenthesis right. I tested it on a calculator putting in (100 * .10) + (((100 + (100 * .10)) * 0.029 +0.030) and it gave me the correct answer.