I have a formula set up to calculate and display whether a customer has paid for the product they’ve taken in full, and, if not, how much they still owe. It looks like this:

IF(SUM({Cases Out}*60-{Money In})=0, “Paid Up”, “Owes $” & SUM({Cases Out}*60-{Money In}))

It works, but the problem is that Airtable seems to take a long time to calculate the answer. When I update the Cases Out field for instance, it’s common to see the output from this function go through two or three “intermediate” answers, where it will display one number, then another, until finally it gets to the right final result. It isn’t a big deal, but it takes a few seconds and makes the user initially feel like it isn’t working right at all. It’s also strange: why is a simple calculation taking so long? I’ve never seen a function output be anything less than instantaneous in Excel or Google Sheets. Is something about the way I’ve written this taking an outsized amount of processing resources?