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

## User Statistics

• 4 Posts
• 0 Solutions
• 0 Kudos given

## IF, then, plus additional validation

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 Less Than and Greater Than

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

## IF Field = x, then = \$5.00, OR IF Field=y, then = \$1.00

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