Forum Discussion
Solved
Query related to excel
Hello Everyone, How can I achieve the following calculation in a formula? If the house value is 750,000 or less the maximum mortgage amount allowed is 80% of that value. If the house value i...
Excel Let's say the value is in A1, try this:
=MIN(750000,A1)*80%+MAX(0,A1-750000)*50%
Excel Let's say the value is in A1, try this:
=MIN(750000,A1)*80%+MAX(0,A1-750000)*50%