Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Could you create table with a compound interest of 5% monthly, If I input a capital it will automatically compute how much my borrower need to pay each semi monthly for the whole year.
Solved by I. W. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/05/2018 - 02:17
Hello Welcome to Gotit pro, your problem will be higly answered here.
User 04/05/2018 - 02:17
thank you
Excelchat Expert 04/05/2018 - 02:17
User 04/05/2018 - 02:17
None so far
Excelchat Expert 04/05/2018 - 02:18
ok
Excelchat Expert 04/05/2018 - 02:18
base on your problem, do you want a table for compound interest right?
User 04/05/2018 - 02:19
yes exactly
Excelchat Expert 04/05/2018 - 02:19
ok, I will try on it first and will discuss you once done
User 04/05/2018 - 02:19
ok sure
Excelchat Expert 04/05/2018 - 02:20
do you want to display with this format?
User 04/05/2018 - 02:21
probably yes to easily check
Excelchat Expert 04/05/2018 - 02:21
ok :)
User 04/05/2018 - 02:23
could you also add additional column for the remaining capital per month? then make the month as semi monthly
Excelchat Expert 04/05/2018 - 02:23
ok this is noted
User 04/05/2018 - 02:23
but still the interest was based on a month
Excelchat Expert 04/05/2018 - 02:23
ok analyzing on it now :)
User 04/05/2018 - 02:23
thanks
Excelchat Expert 04/05/2018 - 02:29
Is it want you want to have?
User 04/05/2018 - 02:29
yeah thats looks great
User 04/05/2018 - 02:30
what was that the another column with the Principal Header?
Excelchat Expert 04/05/2018 - 02:30
oh that was your capital divided only into 24
Excelchat Expert 04/05/2018 - 02:31
since our table was payment for semi monthly for the whole year
Excelchat Expert 04/05/2018 - 02:31
in order to get the total payment per semi monthly we need to get that and add the interest
Excelchat Expert 04/05/2018 - 02:32
i made the interest as 2.5% since it was semi monthly, so it will be 5% for the whole month
User 04/05/2018 - 02:32
I see thanks it looks awesome
User 04/05/2018 - 02:33
does the table will change if I change the principal?
Excelchat Expert 04/05/2018 - 02:33
yes you may try it
User 04/05/2018 - 02:33
ok
User 04/05/2018 - 02:34
it was nice
Excelchat Expert 04/05/2018 - 02:34
thank you :)
Excelchat Expert 04/05/2018 - 02:35
payment there was the sum of the Pincipal coumn & the interest column
Excelchat Expert 04/05/2018 - 02:36
then for the Capital column, that was your remaining balance per semi monthly when we decrease the payment for the previous period
User 04/05/2018 - 02:36
yeah great I love this one
User 04/05/2018 - 02:36
I could i get this file?
Excelchat Expert 04/05/2018 - 02:36
Excelchat Expert 04/05/2018 - 02:36
just click the file
Excelchat Expert 04/05/2018 - 02:37
on the above tool
Excelchat Expert 04/05/2018 - 02:37
Excelchat Expert 04/05/2018 - 02:37
then select microsoft excel
User 04/05/2018 - 02:37
ok thank so much
Excelchat Expert 04/05/2018 - 02:37
no problem :)
Excelchat Expert 04/05/2018 - 02:38
Is there anything else you want to know regarding this issue?
User 04/05/2018 - 02:38
Nothing I'm good with this
Excelchat Expert 04/05/2018 - 02:38
great :)
Excelchat Expert 04/05/2018 - 02:38
Thanks for using Got It Pro. Please give your kind feedback for our service. On your window, kindly don't just close the window, there is an end button there so you could end the session properly & message will appear to ask for the feedback :) Have a good day ahead ^_^

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.