Use the PMT function to calculate the payment for a mortgage or other loan. If you want to know what loan amount you can afford given a payment amount, use PV. Both these functions work the same in Excel and Google Sheets. #excel #googlesheets #workhacks | Spreadsheet Nation