Forum Discussion
Excel
Jul 23, 2022Iron Contributor
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...
- Jul 23, 2022
Excel Let's say the value is in A1, try this:
=MIN(750000,A1)*80%+MAX(0,A1-750000)*50%
Excel
Jul 23, 2022Iron Contributor
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..
HansVogelaar
Jul 23, 2022MVP
You keep on asking the same question:
- ExcelJul 23, 2022Iron ContributorSorry sir,
Actually i solved in with Excel functions, but i do not know how to do in VBA code ?- HansVogelaarJul 23, 2022MVP
Have you tried recording a macro? That might provide a start - you'll have to edit the recorded macro to make it more generic.
- ExcelJul 23, 2022Iron ContributorThank you so much sir.
When i do macro, it give me the VBA code.
Thank you so much sir.