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 is more than 750,000 then the maximum mortgage allowed is 80% of the first 750,000 and 50% of the remainder. Example:
House value is 1,000,000 then maximum mortgage allowed is (750,000*80%)+(250,000*50%)= 725,000
Please help.
Excel Let's say the value is in A1, try this:
=MIN(750000,A1)*80%+MAX(0,A1-750000)*50%
Thank you so much sir. Sir, one more question,
I want to apply VLOOKUP FUNCTION formula in filtered cells only with the help of VBA code. So, what should i write VBA code to give VLOOKUP FUNCTION and it should be dynamic ??
Please help..
Here is a attached file..
You keep on asking the same question:
Excel Let's say the value is in A1, try this:
=MIN(750000,A1)*80%+MAX(0,A1-750000)*50%
