Re: Excel question please ?
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
__________________
There is always light.
If only we’re brave enough to see it.
If only we’re brave enough to be it.
If my post is in bold and this colour, it's a Moderator Request.
|