Excel - IF Function Problem - Expert Solution

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

I took a amortation and tried to adapt it for a land contract payments all work/ looked fine until 0 money was coming in from the start 6% interest for second year (2.7% first yr) $128,579.09 plus they had to pay escrow and any late pay (if pd early they got same discount as late pay) 1st their payment 1085.00 they insisted they would only pay 1000.00 so I rolled that back ea mo into BAL 2nd= I wanted any payment to pay escrow, late, interest then P
Solved by D. S. in 44 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/08/2018 - 03:04
hello there
User 07/08/2018 - 03:05
help not working very well on my end
Excelchat Expert 07/08/2018 - 03:05
can you please guide through what is needed?
User 07/08/2018 - 03:06
I tried to upload my doc to want me to try again?
Excelchat Expert 07/08/2018 - 03:06
yes please
Excelchat Expert 07/08/2018 - 03:12
you there?
User 07/08/2018 - 03:12
now it says my network is busy come back later I can not upload my file
[Uploaded an Excel file]
User 07/08/2018 - 03:13
I cannot just copy paste here any thoughts
Excelchat Expert 07/08/2018 - 03:13
I can see one attached file
Excelchat Expert 07/08/2018 - 03:14
let me see can I download or not
User 07/08/2018 - 03:14
can can you open it
Excelchat Expert 07/08/2018 - 03:15
yes
Excelchat Expert 07/08/2018 - 03:15
now can you brief me please
User 07/08/2018 - 03:15
did itake all that time to upload? and can I see it
Excelchat Expert 07/08/2018 - 03:17
Yes I think so it just got uploaded 2 mins ago
Excelchat Expert 07/08/2018 - 03:17
so can you brief me please where is problem?
User 07/08/2018 - 03:19
I took a amortation and tried to adapt it for a land contract payments all work/ looked fine until 0 money was coming in from the start 6% interest for second year (2.7% first yr) $128,579.09 plus they had to pay escrow and any late pay (if pd early they got same discount as late pay) 1st their payment 1085.00 they insisted they would only pay 1000.00 so I rolled that back ea mo into BAL 2nd= I wanted any payment to pay escrow, late, interest then P
Excelchat Expert 07/08/2018 - 03:20
which sheet we are working on?
User 07/08/2018 - 03:21
2nd 2014-2020
User 07/08/2018 - 03:22
sorry
Excelchat Expert 07/08/2018 - 03:24
So from which cell the problem is?
User 07/08/2018 - 03:26
on 10/15/15 zero payment E = Payment put 0 in E1
User 07/08/2018 - 03:28
NOT sure why Principle is not just 0
User 07/08/2018 - 03:32
I see that negative amount in prin... is being added to balance
Excelchat Expert 07/08/2018 - 03:32
check it
[Uploaded an Excel file]
User 07/08/2018 - 03:33
the down load says something went wrong try again 3 time but I'll try again
User 07/08/2018 - 03:34
still wrong email lasleysue@gmail.com
Excelchat Expert 07/08/2018 - 03:36
where do you feel is wrong?
Excelchat Expert 07/08/2018 - 03:37
try again please
[Uploaded an Excel file]
User 07/08/2018 - 03:37
downloading the file you gave me will not down load
User 07/08/2018 - 03:38
still says on my gray screen something went wrong try again later
Excelchat Expert 07/08/2018 - 03:39
check tjis
Excelchat Expert 07/08/2018 - 03:39
*this
Excelchat Expert 07/08/2018 - 03:39
https://docs.google.com/spreadsheets/d/1iwpSBWTHvbMBtJg4ZmbSJVOxVId7El9X74H2zNlPV0g/edit?usp=sharing
Excelchat Expert 07/08/2018 - 03:44
ok?

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc