Iīm trying to get excel to insert a given value based on some criterias..should be simple, but i canīt get it working
If R2 is <4 it should get the value W2,4-7 should get X2, 8-11 should get Y2 and so on.
I have it working up till 7, but when i get 8, it doesnīt change value?
Formula: copy to clipboard
=IF(R2>=4;(X2);IF(R2>=8;(Y2);IF(R2>=12;(Z2);IF(R2>=16;(AA2);W2))))


As i said, should be simple, but itīs driving me mad