How to create buckets with a formula

Hey Sam, I’ve created something for you here that should solve your problem. You can duplicate the base by clicking the title of the base at the top of the screen and then click the three horizontal dots on the right, allowing you to modify it as needed.

Here’s the formula used in the table:

IF(
  {Column A} < 100, "<100",
  IF(
    AND({Column A} >= 100, {Column A} < 120), 120,
    IF(
      AND({Column A} >= 120, {Column A} < 140), 140,
      BLANK()
    )
  )
)

IF(
  {Column A} < 100, "<100",
  IF(
    AND({Column A} >= 100, {Column A} < 120), 120,
    IF(
      AND({Column A} >= 120, {Column A} < 140), 140,
      BLANK()
    )
  )
)

Thanks Adam,

This helps…what if the values are percentages, how would I represent that?

Cheers

Hm, the percentage values work off the basis of 1, i.e. 100% is 100, 50% is 0.5, 130% is 1.3, etc

So we’d just modify the checks to accommodate that:

IF(
  {Column A} < 1, "<100",
  IF(
    AND({Column A} >= 1, {Column A} < 1.2), 120,
    IF(
      AND({Column A} >= 1.2, {Column A} < 1.4), 140,
      BLANK()
    )
  )
)

Got it, thats worked…thanks