5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Mar 06, 2020
‎Nov 29, 2022

User Statistics

  • 4 Posts
  • 0 Solutions
  • 0 Kudos given
  • 1 Kudos received

User Activity

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…
IF(AND({Total Pages}<“50”,{Total Pages} >“43”,"$3.12"),IF(AND({Total Pages}<“12”,{Total Pages}>“1”,"$1.67")) What am I doing wrong? I’m trying to calculate postage by ranges…stating if Total pages is less than 50 and greater than 43, then $3.12, if t...
Can someone help my brain wrap around this type of formula? I’m trying to get different amounts to populate based on what is selected in a different field. For example) Field 1 is State Trying to get Field 2 to calculate: if Field 1 is Missouri, then...
Kudos from