Posted: 7/8/2016 10:48:42 PM EDT
|
I'm trying to use IF and AND functions. This should be really simple but I can't get the syntax correct, and all of the tutorials/information I've found on the subject gives information for referencing two cells (if cell A1 is X and cell A2 is Y etc)
Here's what I'm trying to do: I want cell A2 to display "X" if the value in cell A1 is >=100, display "Y" if cell A1 is >100 but <=200, display "Z" if cell A1 is >200 BTW this is a really fucking random question for a Friday night. |
|
Quoted:
THANK YOU I had the "AND" operator in the wrong spot. ARF is the shit  Quoted:
Quoted:
=IF(A1>=100,"X",IF(AND(A1>100,A1<=200),"Y",IF(A1>200,"Z",""))) THANK YOU I had the "AND" operator in the wrong spot. ARF is the shit I do shit with Excel that most people pass off as impossible. Reach out anytime for help.
|
|
Quoted:
I do shit with Excel that most people pass off as impossible. Reach out anytime for help. Quoted:
Quoted:
Quoted:
=IF(A1>=100,"X",IF(AND(A1>100,A1<=200),"Y",IF(A1>200,"Z",""))) THANK YOU I had the "AND" operator in the wrong spot. ARF is the shit I do shit with Excel that most people pass off as impossible. Reach out anytime for help. Mind if I keep you in mind as well? Sometimes I need to pull off a Jedi mind trick at work with a spreadsheet. 
|
|
Quoted:
Mind if I keep you in mind as well? Sometimes I need to pull off a Jedi mind trick at work with a spreadsheet.
Quoted:
Quoted:
Quoted:
Quoted:
=IF(A1>=100,"X",IF(AND(A1>100,A1<=200),"Y",IF(A1>200,"Z",""))) THANK YOU I had the "AND" operator in the wrong spot. ARF is the shit I do shit with Excel that most people pass off as impossible. Reach out anytime for help. Mind if I keep you in mind as well? Sometimes I need to pull off a Jedi mind trick at work with a spreadsheet.
Please do. Built a career out of using Excel the way I do. Happy to help. |
|
Quoted:
I do shit with Excel that most people pass off as impossible. Reach out anytime for help. Quoted:
Quoted:
Quoted:
=IF(A1>=100,"X",IF(AND(A1>100,A1<=200),"Y",IF(A1>200,"Z",""))) THANK YOU I had the "AND" operator in the wrong spot. ARF is the shit I do shit with Excel that most people pass off as impossible. Reach out anytime for help. You are a wizard. |