Using a between function

H

HB

Hi

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

Anon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Descenders clipped 0
Space problem with some applications 0
Excel - Wich Function should I use? 1
Countifs with different restrictions 1
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Calculate elapsed time excluding specific timeframe 10
If, Or, and 5

Top