Change military grades into rank

[air force guy]

Afternoon all
Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work consistently, sometimes blank cell is civilian and formula stops working

 

[air force guy]

What problems are you having?

Clicked on the download link on this web site, but it didn't load. I can't seem to make it come up

 

[MARK858]

Have you checked your downloads folder?

 

[air force guy]

Have you checked your downloads folder?

Just did, double clicked it, opened up excel worksheet. Went to file, options, add-ins, manage, excel add-ins, go...and I still don't see it

 

[MARK858]

No your Downloads folder.... normally something like C:\Users\yourusername\Downloads then drag/copy the XL2BB file to C:\Users\yourusername\AppData\Roaming\Microsoft\AddIns (please note that AppData is normally hidden by default so you have to unhide hidden folders if it is).
Once you have it there right click the file, click properties and on the General tab look near the bottom and check if you have Unblock near the bottom, if you do then put a checkmark in the box.
Then open a new Excel file and follow the instructions given in the link.

 

[air force guy]

Just did, double clicked it, opened up excel worksheet. Went to file, options, add-ins, manage, excel add-ins, go...and I still don't see it

Just did all that, still nothing showing up in Excel worksheet (thank you for your help by the way). Is there a next step?

 

[MARK858]

If everything has been done correctly (inc. unblocking the file) then you should have a MrExcel tab on your ribbon, do you not see one?

manage, excel add-ins, go...and I still don't see it

Did you browse to the file?

Just did, double clicked it

I don't understand what you are double clicking

 

[air force guy]

If everything has been done correctly (inc. unblocking the file) then you should have a MrExcel tab on your ribbon, do you not see one?

Did you browse to the file?

I don't understand what you are double clicking

I was click happy and not paying attention...yes I have that tab

 

[air force guy]

I was click happy and not paying attention...yes I have that tab

Do I "capture range" or go to MrExcel forum (after I highlight the cells)

 

[MARK858]

All you do is select your range, click that tab, click capture range, click generate output (you'll probably get a message box to ok) and paste in the reply window.

I'll look at it tomorrow if no-one else does as getting close to 1am here.

 

[air force guy]

All you do is select your range, click that tab, click capture range, click generate output (you'll probably get a message box to ok) and paste in the reply window.

Excel Formulas.xlsx
	C	D	E	F	G
1	GRADE	RANK		Exer/Real	Plan
2	1	2 LT			01A1A
3	2	1 LT			01B1B
4	3	Capt			01C1C
5	4	Maj			01D1D
6	5	Lt Col			01E1E
7	6	Col			01F1F
8	7	Brig Gen
9	8	Maj Gen
10	9	Lt Gen
11	10	Gen
12		CIV
13	31	E1
14	32	E2
15	33	E3
16	34	E4
17	35	E5
18	36	E6
19	37	E7
20	38	E8
21	39	E9
Sheet1

Cell Formulas
Range	Formula
D2:D21	D2	=IF(C2=1,"2 LT",IF(C2=2,"1 LT",IF(C2=3,"Capt",IF(C2=4,"Maj",IF(C2=5,"Lt Col",IF(C2=6,"Col",IF(C2=7,"Brig Gen",IF(C2=8,"Maj Gen",IF(C2=9,"Lt Gen",IF(C2=10,"Gen",IF(C2=31,"E1",IF(C2=32,"E2",IF(C2=33,"E3",IF(C2=34,"E4",IF(C2=35,"E5",IF(C2=36,"E6",IF(C2=37,"E7",IF(C2=38,"E8",IF(C2=39,"E9",IF(C2="","CIV"))))))))))))))))))))