Avatar of mmj1
mmj1
Flag for United States of America asked on

Execl 2013 - IF Statements

II am working with an Excel 2013 document and trying to filter the list to provide me with the following:  The data in my two columns (N and O) have numeric values or they are blank.  I am trying to filter the list to show me the following:  If column "N" has a numeric value >1 AND column "O" has a numeric value >1 - then enter the words 'Has Both" in column "P".  I was thinking I might be able to use an IF statement but not quite sure how to set up the IF statement or should I be using a nested IF statement - or maybe some other function of Excel.  Your assistance is appreciated.  Thanks
Microsoft Excel

Avatar of undefined
Last Comment
mmj1

8/22/2022 - Mon
SOLUTION
Koen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mmj1

ASKER
Thank you for your quick response.
I tried your formula and had an error - so I replaced all the semicolons with commas:

=IF(AND(N1,O1)>1,"Has Both","")

the result in column P shows:  #VALUE!

any further help is appreciated.
SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Saqib Husain

or maybe better

=IF(AND(ISNUMBER(N1),ISNUMBER(O1),N1>1,O1>1),"Has Both","")
ASKER CERTIFIED SOLUTION
regmigrant

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Koen

yes, my bad, too fast, too sloppy... sorry bout that.
Your help has saved me hundreds of hours of internet surfing.
fblack61
mmj1

ASKER
Thank you all very much.
I did use the following from regmigrant:
=if(and(n1>1, o1>1), "Has both","") - and it worked great!

Thanks again to all.