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