excelusername
New Member
- Joined
- Nov 23, 2017
- Messages
- 3
I am trying to put together a nested if statement that contains a number of less than or greater than calculations.
i.e if (A2 <60,A,(if A2>60<70,B,if(A2>70>80,C,if(A2>80,D))))
I can get a result if A2 is less than 60 or greater than 80 but the middle ones don't work. I have looked at adding AND in but can't get that to work either.
Any suggestions?
i.e if (A2 <60,A,(if A2>60<70,B,if(A2>70>80,C,if(A2>80,D))))
I can get a result if A2 is less than 60 or greater than 80 but the middle ones don't work. I have looked at adding AND in but can't get that to work either.
Any suggestions?