Using a between function

  • Thread starter Thread starter HB
  • Start date Start date
H

HB

Hi

I need the following formula
=If(a1 between b1 and c1,"OK","Fault")
What operators should I use?
Thanks
HB
 
HB said:
Hi

I need the following formula
=If(a1 between b1 and c1,"OK","Fault")
What operators should I use?
Thanks
HB
Click to expand...

=IF(AND(A1>B1,A1<C1),"OK","Fault")

You may prefer A1>=B1 and/or A1<=C1. It depends on your application.
 
Back
Top