Can I create a formula for calculating Interest like the one I use in Excel:
UPB*{Interest Rate}*(({To Date}-{Bill of Sale Date}))/365
In Airtable, this formula generates a NaN error message:
I got it to work by breaking it out into two cells and usi...