Skip to main content

MINOR formula

  • February 23, 2023
  • 1 reply
  • 5 views

Forum|alt.badge.img

Hello everyone,

I'm wondering if AirTable has a formula that looks for the 2nd minor value (like MINOR on excel). I only found the MIN formula, that looks up for the minor value, without letting me search for the 2nd minor value.

Any help will be appreciated!

Thank you

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6416 replies
  • February 24, 2023

Unfortunately, no.  You can create a workaround solution by using formula fields and conditional lookups though and I've created that for you here.  You can duplicate the base to view all the formulas used