Cable Forum - Excel question please ?

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - Excel question please ? (https://www.cableforum.uk/board/showthread.php?t=33705906)

Mike	08-01-2018 14:45

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

Hugh	08-01-2018 15:27

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

Mike	08-01-2018 15:35

Re: Excel question please ?

Quote:

Originally Posted by Hugh (Post 35931563)

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

All times are GMT +1. The time now is 14:41.