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...