I have to group some variables and assign the number in () into the following: <=5(1) 6-10(2) >10(3) Unknown(9) I can get the numbers in the right category except for Unknown (9). The variable for 9 is 99 in the spreadsheet. this is the formula that I used and it generates a 3 for 99 and that is not what I need. =IF(E2<=5,1,IF(E2<=10,2,IF(E2>=11,3,IF(E2=99,9))))
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
Finding a professional expert in "partial differential equations" in the advanced level is difficult.
You can find this expert in "Assignmentexpert.com" with confidence.
Exceptional experts! I appreciate your help. God bless you!
Comments
Leave a comment