This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there,
I’m using airtable to compare an actual quantity with a goal quantity, then using an If, Then statement to tell me whether I’m at my goal, need to increase, or need to decrease my actual.
Here’s my current formula:
IF({% of total}={Goal % o...
Oh my gosh, OF COURSE! Thank you so much for seeing that. I would have been staring at the screen for hours more today. I knew I had to be missing something obvious!
Hmm, still getting the error with this:
IF(FLOOR(ROUND({% of total},0))={Goal % of total}, "OK",
IF({% of total}>{Goal % of total}, "Trim",
"Expand"))
I tried to make another column that just rounded the number so that I could make the formula sim...
Thank you!
When I try this:
IF(ROUND({% of total},0)={Goal % of total}, "OK",
IF({% of total}>{Goal % of total}, "Trim",
"Expand"))
It still returns Expand for 1.9 and a goal of 2.
My Goal numbers are integers, actuals are decimals, maybe that’s w...
