Skip to main content

IF, then, plus additional validation

  • March 10, 2020
  • 1 reply
  • 9 views
L

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

J
Forum|alt.badge.img+18
  • Jeremy_Oglesby
  • Inspiring
  • 1691 replies
  • March 10, 2020
IF(
  {No Charge} = "yes",
  0,
  IF(
    {Total Pages} < 12,
    1.67,
    IF(
      {Total Pages} < 43,
      2.00,
      IF(
        {Total Pages} < 60,
        3.12
      )
    )
  )
)


Terms & ConditionsAccessibility statement