Formula returns the number 29 if within a specific range

[Jarrod_McDaniel]

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
)
)

[JonathanBowen]

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
)

JB