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
)
)
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.