IF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi
try
=IF(B3>99,0,IF(B3>49,1,0))

--
Regards
Frank Kabel
Frankfurt, Germany

Steve Connor said:
I am trying to get a result in a cell based on 3 criteria, if cell
Click to expand...
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?
 
Alternatively,

AND(B3>49,B3<=99)

Steve Connor said:
I am trying to get a result in a cell based on 3 criteria, if cell B3<50
Click to expand...
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?
 
Back
Top