Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 23, 2020 06:14 AM
I’m trying to return the same number if the value of a cell is within a specific range. If the cell C value is within .875-1.125 it returns $29. If outside of that range it returns $56. This is the formula I tried that didn’t work:
IF(
C>=.875,
29,
IF(
C<=1.125,
29,
56
)
)
Jan 23, 2020 07:48 AM
HI @Jarrod_McDaniel - you need a small change to this. You want to say “If both of these things are true (>= 0.875 AND <= 1.125) then 29 otherwise 56”. Try this:
IF(
AND(C >= 0.875, C <= 1.125),
29,
56
)
JB