Mar 09, 2020 06:03 PM
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…
Mar 09, 2020 06:15 PM
IF( {No Charge} = "yes", 0, IF( {Total Pages} < 12, 1.67, IF( {Total Pages} < 43, 2.00, IF( {Total Pages} < 60, 3.12 ) ) ) )