Excel question please ?
Hi all
Hope someone can help please
I have a 4 column spreadsheet
In column A B and C I have figures. If figure C is between the number in A and B I would like column D to say Y or if it's not N
The formula I currently have is =IF(AND(C3>=A3,C3<=B3),"Y","N")
Something isn't working
Any ideas
Thanks for your time
Regards
Mike
Last edited by Mike; 08-01-2018 at 14:49.
|