Hello,
I previously received help with this, but I had to add more information and it caused an issue. I'm trying to calculate for cell B34 (appraisal). I'm not sure what's wrong with my formula but, the formula isn't working for multi family or investment. The base amount for multi family is 650 and investment is 550, but if it's an FHA (B7="yes"), then I need to add 30. If the appraised value is over 999,999 then add 100, and over 1,499,999 add an additional 100.
Last edited by mskwood89; 02-14-2024 at 01:30 PM.
You have the closing parens in the wrong place: Not sure of your Home Equity logic (the 130 vs 485) but the additional fees should work now....
=IF(B8="Multi Family",650,IF(B8="Investment",550,IF(B6="Home Equity",130,485)))+IF(B7="yes",30,0)+IF(B10>999999,100,0)+IF(B10>1499999,100,0)
Bernie Deitrick
Excel MVP 2000-2010
Actually, if it's a home equity then the value should always be 130 and everything else doesn't apply. Is there a way to add that in?
And thanks so much for your previous help. I added to your rep as well.
Try this:
=IF(B6="Home Equity",130,IF(B8="Multi Family",650,IF(B8="Investment",550,485))+IF(B7="yes",30,0)+IF(B10>999999,100,0)+IF(B10>1499999,100,0))
I thought I tried that, but I guess not. That worked though. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks