Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

IF, then, plus additional validation

Topic Labels: Formulas
353 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m using this current Formula and it works fine:
IF( {Total Pages} < 12, 1.67, IF( {Total Pages} < 43, 2.00, IF( {Total Pages} < 60, 3.12 )))
I’m hoping to add an element that IF( {NO CHARGE} is “yes”, then $0
What is the best way to add this…

1 Reply 1
IF(
  {No Charge} = "yes",
  0,
  IF(
    {Total Pages} < 12,
    1.67,
    IF(
      {Total Pages} < 43,
      2.00,
      IF(
        {Total Pages} < 60,
        3.12
      )
    )
  )
)