Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF Less Than and Greater Than

Topic Labels: Formulas
Solved
Jump to Solution
1165 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

See Solution in Thread

1 Reply 1

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.