Thread: Excel question please ?
View Single Post
Old 08-01-2018, 14:45   #1
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
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.
Mike is offline   Reply With Quote