IF Function

[Guest]

I am trying to get a result in a cell based on 3 criteria, if cell B3<50 return 0, if cell B3>49 return 1, if cell B3>99 return 0. Or in other words if cell B3 is between 50 and 99 return True. Have tried using the IF function but cannot return correct results, I'm guessing I need to nest another function but not sure which one
Hope someone out there can help

Thanks

Steve.

 

[Frank Kabel]

Hi
try
=IF(B3>99,0,IF(B3>49,1,0))

--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to get a result in a cell based on 3 criteria, if cell

B3<50 return 0, if cell B3>49 return 1, if cell B3>99 return 0. Or in
other words if cell B3 is between 50 and 99 return True. Have tried
using the IF function but cannot return correct results, I'm guessing I
need to nest another function but not sure which one?

 

[RK]

Alternatively,

AND(B3>49,B3<=99)

I am trying to get a result in a cell based on 3 criteria, if cell B3<50

return 0, if cell B3>49 return 1, if cell B3>99 return 0. Or in other words
if cell B3 is between 50 and 99 return True. Have tried using the IF
function but cannot return correct results, I'm guessing I need to nest
another function but not sure which one?