Trying to calculate maximum loan amount based on max allowed payment

[Liz_Trice]

I’m trying to create a calculator that shows what the maximum loan amount can be based on what a borrower can afford in a monthly payment.

I’ve tried this but I keep getting "invalid formula

Maximum Payment Allowed by Construction Loan * ((1 + (Interest Rate on a new secondary mortgage/100)) ^ (New Loan Amortization Period in Years * 12) - 1 )
/
( (Interest Rate on a new secondary mortgage/100) * (1+ (Interest Rate on a new secondary mortgage / 100) ) ^ ( New Loan Amortization Period in Years * 12)

[Max]

Hi there, @Liz_Trice

There was missing ) at the end of the formula. I’ve added it there and now everything is working correctly:

Please check it out