Thread: Excel question please ?
View Single Post
Old 08-01-2018, 15:35   #3
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Re: Excel question please ?
Quote:
Originally Posted by Hugh View Post
Try this (works on my Excel).

=IF(AND(C1>A1,C1<B1),"Y","N")

This will only work if column b is greater than column a
Many thanks will give it a go

Got my > and < messed up...

Regards
Mike is offline   Reply With Quote