You think too much. That’s where IF formulas come in with Airtable spreadsheets because they help establish the conditions around which you are already wasting brain space to make decisions about… when the formula field could just provide the data to do that for you.
Here are a few videos highlighting how you can use formulas in Airtable