Percentage formula, part 2

[Sami66]

Spreadsheet is as follows:

Column

C=BEGINNING BALANCE
D=PURCHASES
E=PAYMENTS
F=CREDITS
G=SERVICE CHARGE
H=NEW BALANCE

NEED HELP FOR:

1. SERVICE CHARGE=3.15% * (BEGINNING BALANCE-PAYMENTS-CREDITS)

2. NEW BALANCE=BEGINNING BALANCE+PURCHASES-PAYMENTS-CREDITS+SERVIC
CHARGE)

THATS PRETTY MUCH IT FOR THE PROBLEMS I AM HAVING....I WILL GREATL
APPRECIATE ANY GUIDANCE GIVEN!!!!

THANKS!

SA

 

[JE McGimpsey]

One way:

1)

G2: = 3.15% * (C2 - E2 - F2)


2)

H2: = C2 + D2 - E2 - F2 + G2