Help

IF, then, plus additional validation

Topic Labels: Formulas
1277 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Leah_Huelsing
5 - Automation Enthusiast
5 - Automation Enthusiast

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
      )
    )
  )
)