# IF Less Than and Greater Than

Topic Labels: Formulas
Solved
2163 1
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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 total pages is less than 12 and greater than 1, then \$1.67 and so on.

1 Solution

Accepted Solutions
18 - Pluto

Use a nest `IF`. Put all the values in order and use the same comparison operator.

``````IF( {Total Pages} < 12,
1.67,
IF( {Total Pages} < 43,
2.00,
IF( {Total Pages} < 50,
3.12
)))

``````

I’m not sure what \$\$\$ you want for 44-49 pages, so I just put a random number that was between the two others. This might not be quite what you want, but hopefully it will send you in the right direction.

18 - Pluto

Use a nest `IF`. Put all the values in order and use the same comparison operator.

``````IF( {Total Pages} < 12,
1.67,
IF( {Total Pages} < 43,
2.00,
IF( {Total Pages} < 50,
3.12
)))

``````

I’m not sure what \$\$\$ you want for 44-49 pages, so I just put a random number that was between the two others. This might not be quite what you want, but hopefully it will send you in the right direction.