Home

Formula to add a comma to a number as well as a decimal even when .0

%3CLINGO-SUB%20id%3D%22lingo-sub-432183%22%20slang%3D%22en-US%22%3EFormula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432183%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20pulling%20information%20from%20one%20tab%20(Tab%20name%20is%20Stats%20and%20the%20cell%20is%20formatted%20as%20a%20number)%20to%20another%20(Tab%20name%20is%20Stat%20FS).%20I%20need%20the%20formula%20to%20carry%20over%20the%20decimal%20even%20if%20it's%20a%20.0%2C%20but%20not%20to%20add%20a%20.0%20if%20none%20exists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStats-%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EG%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3CTD%3EI%3C%2FTD%3E%3CTD%3EJ%3C%2FTD%3E%3CTD%3EK%3C%2FTD%3E%3CTD%3EL%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3EN%3C%2FTD%3E%3CTD%3EO%3C%2FTD%3E%3CTD%3EP%3C%2FTD%3E%3CTD%3EQ%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3CTD%3EU%3C%2FTD%3E%3CTD%3EV%3C%2FTD%3E%3CTD%3EW%3C%2FTD%3E%3CTD%3EX%3C%2FTD%3E%3CTD%3EY%3C%2FTD%3E%3CTD%3EZ%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECOMP%20%25%3C%2FTD%3E%3CTD%3EPASS%20YDS%3C%2FTD%3E%3CTD%3EPASS%20TD%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3EATT%3C%2FTD%3E%3CTD%3ERUSH%20YDS%3C%2FTD%3E%3CTD%3EYDS%2FATT%3C%2FTD%3E%3CTD%3ERUSH%20TD%3C%2FTD%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3E72%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E61%3C%2FTD%3E%3CTD%3E2221%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E63%3C%2FTD%3E%3CTD%3E274%3C%2FTD%3E%3CTD%3E4.3%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3CTD%3E1078%3C%2FTD%3E%3CTD%3E12.1%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E118%3C%2FTD%3E%3CTD%3E1334%3C%2FTD%3E%3CTD%3E11.31%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3E472%3C%2FTD%3E%3CTD%3E9.8%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3E51%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E61%3C%2FTD%3E%3CTD%3E984%3C%2FTD%3E%3CTD%3E16.1%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E60.9%3C%2FTD%3E%3CTD%3E2868%3C%2FTD%3E%3CTD%3E18%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E184%3C%2FTD%3E%3CTD%3E754%3C%2FTD%3E%3CTD%3E4.1%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3E873%3C%2FTD%3E%3CTD%3E13.4%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E10.5%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E56%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3E82%3C%2FTD%3E%3CTD%3E9.5%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStat%20FS%20(What%20it%20actually%20reads)-%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EI%3C%2FTD%3E%3CTD%3EJ%3C%2FTD%3E%3CTD%3EK%3C%2FTD%3E%3CTD%3EL%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3EN%3C%2FTD%3E%3CTD%3EO%3C%2FTD%3E%3CTD%3EP%3C%2FTD%3E%3CTD%3EQ%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3CTD%3EU%3C%2FTD%3E%3CTD%3EV%3C%2FTD%3E%3CTD%3EW%3C%2FTD%3E%3CTD%3EX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECAT%201%3C%2FTD%3E%3CTD%3ESTAT%201%3C%2FTD%3E%3CTD%3ECAT%202%3C%2FTD%3E%3CTD%3ESTAT%202%3C%2FTD%3E%3CTD%3ECAT%203%3C%2FTD%3E%3CTD%3ESTAT%203%3C%2FTD%3E%3CTD%3ECAT%204%3C%2FTD%3E%3CTD%3ESTAT%204%3C%2FTD%3E%3CTD%3ECAT%205%3C%2FTD%3E%3CTD%3ESTAT%205%3C%2FTD%3E%3CTD%3ECAT%206%3C%2FTD%3E%3CTD%3ESTAT%206%3C%2FTD%3E%3CTD%3ECAT%207%3C%2FTD%3E%3CTD%3ESTAT%207%3C%2FTD%3E%3CTD%3ECAT%208%3C%2FTD%3E%3CTD%3ESTAT%208%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E72%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECOMP%20%25%3C%2FTD%3E%3CTD%3E61%3C%2FTD%3E%3CTD%3EPASS%20YDS%3C%2FTD%3E%3CTD%3E2221%3C%2FTD%3E%3CTD%3EPASS%20TD%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3ERUSH%20YDS%3C%2FTD%3E%3CTD%3E274%3C%2FTD%3E%3CTD%3ERUSH%20TD%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E1078%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E12.1%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E118%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E1334%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E11.31%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E472%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E9.8%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E51%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E61%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E984%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E16.1%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECOMP%20%25%3C%2FTD%3E%3CTD%3E60.9%3C%2FTD%3E%3CTD%3EPASS%20YDS%3C%2FTD%3E%3CTD%3E2868%3C%2FTD%3E%3CTD%3EPASS%20TD%3C%2FTD%3E%3CTD%3E18%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3ERUSH%20YDS%3C%2FTD%3E%3CTD%3E754%3C%2FTD%3E%3CTD%3ERUSH%20TD%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E873%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E13.4%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E10.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E56%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E82%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E9.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStat%20FS%20(What%20I%20need%20it%20to%20read)-%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EI%3C%2FTD%3E%3CTD%3EJ%3C%2FTD%3E%3CTD%3EK%3C%2FTD%3E%3CTD%3EL%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3EN%3C%2FTD%3E%3CTD%3EO%3C%2FTD%3E%3CTD%3EP%3C%2FTD%3E%3CTD%3EQ%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3CTD%3EU%3C%2FTD%3E%3CTD%3EV%3C%2FTD%3E%3CTD%3EW%3C%2FTD%3E%3CTD%3EX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECAT%201%3C%2FTD%3E%3CTD%3ESTAT%201%3C%2FTD%3E%3CTD%3ECAT%202%3C%2FTD%3E%3CTD%3ESTAT%202%3C%2FTD%3E%3CTD%3ECAT%203%3C%2FTD%3E%3CTD%3ESTAT%203%3C%2FTD%3E%3CTD%3ECAT%204%3C%2FTD%3E%3CTD%3ESTAT%204%3C%2FTD%3E%3CTD%3ECAT%205%3C%2FTD%3E%3CTD%3ESTAT%205%3C%2FTD%3E%3CTD%3ECAT%206%3C%2FTD%3E%3CTD%3ESTAT%206%3C%2FTD%3E%3CTD%3ECAT%207%3C%2FTD%3E%3CTD%3ESTAT%207%3C%2FTD%3E%3CTD%3ECAT%208%3C%2FTD%3E%3CTD%3ESTAT%208%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E72%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E7.0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECOMP%20%25%3C%2FTD%3E%3CTD%3E61.0%3C%2FTD%3E%3CTD%3EPASS%20YDS%3C%2FTD%3E%3CTD%3E2%2C221%3C%2FTD%3E%3CTD%3EPASS%20TD%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3ERUSH%20YDS%3C%2FTD%3E%3CTD%3E274%3C%2FTD%3E%3CTD%3ERUSH%20TD%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E1%2C078%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E12.1%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E118%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E1%2C334%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E11.31%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E472%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E9.8%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E51%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E3.0%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E61%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E984%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E16.1%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECOMP%20%25%3C%2FTD%3E%3CTD%3E60.9%3C%2FTD%3E%3CTD%3EPASS%20YDS%3C%2FTD%3E%3CTD%3E2%2C868%3C%2FTD%3E%3CTD%3EPASS%20TD%3C%2FTD%3E%3CTD%3E18%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3ERUSH%20YDS%3C%2FTD%3E%3CTD%3E754%3C%2FTD%3E%3CTD%3ERUSH%20TD%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EREC%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3EREC%20YDS%3C%2FTD%3E%3CTD%3E873%3C%2FTD%3E%3CTD%3EYDS%2FREC%3C%2FTD%3E%3CTD%3E13.4%3C%2FTD%3E%3CTD%3EREC%20TD%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E10.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E7.0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%23N%2FA%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESOLO%3C%2FTD%3E%3CTD%3E56%3C%2FTD%3E%3CTD%3EAST%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E82%3C%2FTD%3E%3CTD%3ETFL%3C%2FTD%3E%3CTD%3E9.5%3C%2FTD%3E%3CTD%3ESACKS%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3EINT%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EPASS%20DEF%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3EFF%3C%2FTD%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20of%20the%20formula%20I%20am%20using%20is%3A%3C%2FP%3E%3CP%3E%3DIF(D12%3D%22QB%22%2CStats!G12%2CIF(D12%3D%22RB%22%2CStats!K12%2CIF(SUM(COUNTIF(D12%2C%7B%22WR%22%2C%22TE%22%2C%22FB%22%7D))%2CStats!O12%2CIF(SUM(COUNTIF(D12%2C%7B%22EDGE%22%2C%22DL%22%2C%22LB%22%2C%22CB%22%2C%22S%22%7D))%2CStats!S12%2C%22%22))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20told%20I%20need%20another%20if%20and%20a%20MOD%2C%20but%20for%20the%20life%20of%20me%2C%20I'm%20not%20sure%20exactly%20where%20or%20how%20to%20use%20that.%20I%20need%20everything%20from%20the%20Stat%20FS%20tab%20to%20read%20exactly%20how%20it%20does%20in%20the%20Stats%20tab%2C%20so%20a%20.0%20when%20there%20is%20a%20.0%20and%20have%20a%20comma%20in%20numbers%20that%20are%20in%20the%20thousands.%20Can%20anyone%20point%20me%20in%20the%20right%20direction%20on%20this%3F%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-432183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433471%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433471%22%20slang%3D%22en-US%22%3EI%20haven%E2%80%99t%20tested%2C%20but%20try%20this%20custom%20format%3A%3CBR%20%2F%3E%23%2C%23%230.0%23%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433490%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BUnfortunately%20that%20added%20a%20decimal%20point%20to%20every%20cell.%20I%20just%20need%20it%20in%20the%20cells%20that%20originally%20have%20decimal%20points.%20The%20.1%2C%20.2%2C%20.3%20etc%20show%20up%2C%20but%20the%20.0%20do%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20the%20document%2C%20if%20you%20want%20to%20see%20the%20entire%20thing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433498%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433498%22%20slang%3D%22en-US%22%3EModify%20the%20custom%20format%20to%20this%3A%3CBR%20%2F%3E%23%2C%23%230.%23%23%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433506%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BThat%20adds%20a%20decimal%20point%20to%20everything%2C%20but%20no%20.0%20where%20I%20need%20it%20and%20decimal%20points%20in%20cells%20that%20I%20don't%20need%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433525%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433525%22%20slang%3D%22en-US%22%3ETry%20the%20General%20format.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433527%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20add%20a%20comma%20to%20a%20number%20as%20well%20as%20a%20decimal%20even%20when%20.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BIt's%20already%20at%20the%20general%20format.%20For%20some%20reason%2C%20the%20general%20format%20doesn't%20pull%20exact%20data%20the%20way%20it%20was%20entered%20from%20another%20cell.%20Not%20sure%20why.%20I%20would%20think%20that%20if%20I%20have%20a%20formula%20that%20pulls%20data%20from%20another%20cell%2C%20it%20would%20copy%20that%20data%20exactly%2C%20but%20it%20does%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E
cpavl1113
New Contributor

I am pulling information from one tab (Tab name is Stats and the cell is formatted as a number) to another (Tab name is Stat FS). I need the formula to carry over the decimal even if it's a .0, but not to add a .0 if none exists.

 

Example:

 

Stats-

GHIJKLMNOPQRSTUVWXYZ
COMP %PASS YDSPASS TDINTATTRUSH YDSYDS/ATTRUSH TDRECREC YDSYDS/RECREC TDSOLOASTTOTALTFLSACKSINTPASS DEFFF
            36367212.57003
612221166632744.36            
        89107812.18        
        118133411.319        
        484729.87        
            28235130150
        6198416.111        
60.928681891847544.115            
        6587313.45        
            24265010.57010
                    
                    
                    
            5626829.50261

 

Stat FS (What it actually reads)-

IJKLMNOPQRSTUVWX
CAT 1STAT 1CAT 2STAT 2CAT 3STAT 3CAT 4STAT 4CAT 5STAT 5CAT 6STAT 6CAT 7STAT 7CAT 8STAT 8
SOLO36AST36TOTAL72TFL12.5SACKS7INT0PASS DEF0FF3
COMP %61PASS YDS2221PASS TD16INT6RUSH YDS274RUSH TD60000
REC89REC YDS1078YDS/REC12.1REC TD8 0 0 0 0
REC118REC YDS1334YDS/REC11.31REC TD9 0 0 0 0
REC48REC YDS472YDS/REC9.8REC TD7 0 0 0 0
SOLO28AST23TOTAL51TFL3SACKS0INT1PASS DEF5FF0
REC61REC YDS984YDS/REC16.1REC TD11 0 0 0 0
COMP %60.9PASS YDS2868PASS TD18INT9RUSH YDS754RUSH TD150000
REC65REC YDS873YDS/REC13.4REC TD5 0 0 0 0
SOLO24AST26TOTAL50TFL10.5SACKS7INT0PASS DEF1FF0
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
SOLO56AST26TOTAL82TFL9.5SACKS0INT2PASS DEF6FF

1

 

 

 

 

Stat FS (What I need it to read)-

IJKLMNOPQRSTUVWX
CAT 1STAT 1CAT 2STAT 2CAT 3STAT 3CAT 4STAT 4CAT 5STAT 5CAT 6STAT 6CAT 7STAT 7CAT 8STAT 8
SOLO36AST36TOTAL72TFL12.5SACKS7.0INT0PASS DEF0FF3
COMP %61.0PASS YDS2,221PASS TD16INT6RUSH YDS274RUSH TD60000
REC89REC YDS1,078YDS/REC12.1REC TD8 0 0 0 0
REC118REC YDS1,334YDS/REC11.31REC TD9 0 0 0 0
REC48REC YDS472YDS/REC9.8REC TD7 0 0 0 0
SOLO28AST23TOTAL51TFL3.0SACKS0INT1PASS DEF5FF0
REC61REC YDS984YDS/REC16.1REC TD11 0 0 0 0
COMP %60.9PASS YDS2,868PASS TD18INT9RUSH YDS754RUSH TD150000
REC65REC YDS873YDS/REC13.4REC TD5 0 0 0 0
SOLO24AST26TOTAL50TFL10.5SACKS7.0INT0PASS DEF1FF0
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 
SOLO56AST26TOTAL82TFL9.5SACKS0INT2PASS DEF6FF

1

 

 

 

 

An example of the formula I am using is:

=IF(D12="QB",Stats!G12,IF(D12="RB",Stats!K12,IF(SUM(COUNTIF(D12,{"WR","TE","FB"})),Stats!O12,IF(SUM(COUNTIF(D12,{"EDGE","DL","LB","CB","S"})),Stats!S12,""))))

 

 

I've been told I need another if and a MOD, but for the life of me, I'm not sure exactly where or how to use that. I need everything from the Stat FS tab to read exactly how it does in the Stats tab, so a .0 when there is a .0 and have a comma in numbers that are in the thousands. Can anyone point me in the right direction on this? Thanks!

 

 

6 Replies
Highlighted
I haven’t tested, but try this custom format:
#,##0.0#

@Twifoo Unfortunately that added a decimal point to every cell. I just need it in the cells that originally have decimal points. The .1, .2, .3 etc show up, but the .0 do not.

 

Attached is the document, if you want to see the entire thing.

Modify the custom format to this:
#,##0.##

@Twifoo That adds a decimal point to everything, but no .0 where I need it and decimal points in cells that I don't need it.

@Twifoo It's already at the general format. For some reason, the general format doesn't pull exact data the way it was entered from another cell. Not sure why. I would think that if I have a formula that pulls data from another cell, it would copy that data exactly, but it does not.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies