Thread
:
Excel question please ?
View Single Post
08-01-2018, 15:35
#
3
Mike
cf.mega poster
Join Date: Jan 2004
Age: 61
Posts: 2,242
Re: Excel question please ?
Quote:
Originally Posted by
Hugh
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
View Public Profile
Visit Mike's homepage!
Find More Posts by Mike