Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Excel question please ?

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion

Excel question please ?
Reply
 
Thread Tools
Old 08-01-2018, 15: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 15:49.
Mike is offline   Reply With Quote
Advertisement
Old 08-01-2018, 16:27   #2
Hugh
laeva recumbens anguis
Cable Forum Team
 
Hugh's Avatar
 
Join Date: Jun 2006
Age: 67
Services: Premiere Collection
Posts: 42,042
Hugh has a golden auraHugh has a golden aura
Hugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden auraHugh has a golden aura
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.
Hugh is online now   Reply With Quote
Old 08-01-2018, 16:35   #3
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
Re: Excel question please ?

Quote:
Originally Posted by Hugh View Post
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 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 22:07.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.