mmj1
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or maybe better
=IF(AND(ISNUMBER(N1),ISNUM BER(O1),N1 >1,O1>1)," Has Both","")
=IF(AND(ISNUMBER(N1),ISNUM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes, my bad, too fast, too sloppy... sorry bout that.
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.
I did use the following from regmigrant:
=if(and(n1>1, o1>1), "Has both","") - and it worked great!
Thanks again to all.
ASKER
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.