LinkBack URL
About LinkBacks
ok I have to do a formula to determine the service charge in my column F and it says Service charge (Cell F4)=3.25% * (Beginning Balance-Payments-Credits) PLEASE HELP TY
ok I have to do a formula to determine the service charge in my column F and it says Service charge (Cell F4)=3.25% * (Beginning Balance-Payments-Credits) PLEASE HELP TY
Hi lsapp289,
Welcome to the forum.
Correct me if I am wrong, Service charge is 3.25% of the amount which will be left after deducting payments and credits from Beginning balance.. Or you wanted to ask something else ?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
I have to use the formula to determine theve service charge =3.25%* (Beginning Balance, Payments and credits I have to put the answer in column F in the cell
okay..
=3.25%*(a1-a2-a3)
where a1 = begining balance, a2 = payments and a3 = credits
Regards,
DILIPandey
<click on below * if this helps>
thank you now I got to get the new balance beginning balance+Purchases-Credits-payments+service charge please help ty
You can use below formula logic:-
New Balance = a1+a4-a3-a2+(3.25%*(a1-a2-a3))
where a4=purchases, a1 = begining balance, a2 = payments and a3 = credits
If you face any challenge, upload a sample workbook.. thanks.
Regards,
DILIPandey
<click on below * if this helps>
Hi all my name is Jay. Nice to be in this group
Would appreciate some help with this if poss. I want to show where a person is to target. mine is slightly different as it must show a percentage based on time frame. i.e. john has done 10, target is 100 and target must be reached by the end of month.
Hi jayson,
suggest you to post this query as new thread....also find time to read forum rules:-
http://www.excelforum.com/forum-rule...rum-rules.html
Regards,
DILIPandey
<click on below * if this helps>
hi here is a video of the page i am stuck on I did the best i can to show you that one question im stuck on still i emailed you it
Suggest you to post video here only ....
Regards,
DILIPandey
<click on below * if this helps>
ok i need help in excel Here is a further explanation of the above formula using actual data. Looking at the screenshot below, for the North region, the “First Quarter Total” is 31,000. The “Total” for the second quarter is 49,650. So you will subtract the cell that contains 31,000 from the cell that contains 49,650 to get 18,650. Then divide that result by the cell that contains 31,000 to get 60.16%. This means that the second quarter revenue total has increased from the first quarter revenue total by 60.16%. Be sure to change the cell format for the final results in the cell to a percentage. i attached my spreadsheet
Okay... use the formula:-
Formula:
Please Login or Register to view this content.
see attached:- Lorraine final project.xlsx
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks