For my requirements in practice, i have a table for dimensions (width and depth) and ares and analysing rent GBP £psf or £psm. I have designed the table for entering the dimensions either or both in imperial or metric - also metric dimensions to convert automatically to imperial using duo-decimals - multiply to sqft and/or sqm. Also average differences in depth or width by adding the two widths or depths then dividing by 2.
Before your formula I have been entering the resultant (auto) sqm converted into sqft into a second field sqft (which doubles as manual entry sqft) before the next stage analysing the rent. Using the formula will enable me to skip entering the auto sqft.
Glad to see that you were able to get something that works!
To clarify something from your initial post…
The OR() function doesn’t return the actual values of the listed fields. Similar to AND(), it returns a boolean value—True or False—based on the passed arguments. That value is then converted to a number—1 for True, 0 for False—to be the field output.
Here’s the brief rundown of OR() vs AND():
The OR() function will return True if any of the arguments passed are truthy (equivalent to True: a non-empty string, a non-zero number, etc.); otherwise it will return False.
The AND() function will return True only when all of the arguments passed are truthy.
This explains why 45 became 1: 45 is a non-zero number, which meant that at least one of the passed arguments was truthy, so OR() returned True, which became 1.