Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula returns the number 29 if within a specific range

Topic Labels: Formulas
1057 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jarrod_McDaniel
4 - Data Explorer
4 - Data Explorer

I’m trying to return the same number if the value of a cell is within a specific range. If the cell C value is within .875-1.125 it returns $29. If outside of that range it returns $56. This is the formula I tried that didn’t work:

IF(
C>=.875,
29,
IF(
C<=1.125,
29,
56
)
)

1 Reply 1

HI @Jarrod_McDaniel - you need a small change to this. You want to say “If both of these things are true (>= 0.875 AND <= 1.125) then 29 otherwise 56”. Try this:

IF(
  AND(C >= 0.875, C <= 1.125),
  29,
  56
)

Screenshot 2020-01-23 at 15.47.56

JB