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…
Page 1 / 1
IF(
{No Charge} = "yes",
0,
IF(
{Total Pages} < 12,
1.67,
IF(
{Total Pages} < 43,
2.00,
IF(
{Total Pages} < 60,
3.12
)
)
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.