ir based on data =IFERROR(IF([@PCT3]*1>Letters!$D$2,"A+",IF([@PCT3]*1>Letters!$D$3,"A",IF([@PCT3]*1>Letters!$D$4,"A/IF([@PCT3]*1>Letters!$D$5,"B+",IF([@PCT3]*1>Letters!$D$6,"B",IF([@PCT3]*1>Letters!$D$7,"B-,IF([@PCT3]*1>Letters!$D$8,"C+",IF([@PCT3]*1>Letters!$D$9,"C",IF([@PCT3]*1>Letters!$D$10,"C-,IF([@PCT3]*1>Letters!$D$11,"D+",I([@PCT3]*1>Letters!$D$12,"D",IF([@PCT3]*1>Letters!$D$13,"D-,IF([@PCT3]*1>Letters!$D$14,"F+",IF([@PCT3]*1>Letters!$D$15,"F",IF([@PCT3]*1>Letters!$D$16,"F-","--"))))))))))))))),"--")
=IFERROR(IF([@Percentile29]*1>Letters!$D$2,"A+",IF([@Percentile29]*1>Letters!$D$3,"A",IF([@Percentile29]*1>Letters!$D$4,"A-,IF([@Percentile29]*1>Letters!$D$5,"B+",IF([@Percentile29]*1>Letters!$D$6,"B",IF([@Percentile29]*1>Letters!$D$7,"B-,IF([@Percentile29]*1>Letters!$D$8,"C+",IF([@Percentile29]*1>Letters!$D$9,"C",IF([@Percentile29]*1>Letters!$D$10,"C-,IF([@Percentile29]*1>Letters!$D$11,"D+",IF([@Percentile29]*1>Letters!$D$12,"D",IF([@ercentile29]*1>Letters!$D$13,"D-,IF([@Percentile29]*1>Letters!$D$14,"F+",IF([@Percentile29]*1>Letters!$D$15,"F",IF([@Percentile29]*1>Letters!$D$16,"F-","--"))))))))))))))),"--")
=IF([@Data30]="--","--",IF([@Data30]="NM",-15,IF([@Data30]0,-15,IF([@Data30]<2,25,IF([@Data30]<4,20,IF([@Data30]<7.5,15,IF([@Data30]<11,10,IF([@Data30]<20,5,0))))))))
Applied on 100+ Fields
Column formula cell Differntials (x= leave blank) Symbol A X Company B X Industry C X Price D X Price Target Estimates: OM Score E OM Price Target K X OM Score Ranking F Price/OM Target % Y Sell Side Target CW X Price/SS target % CX Price/SS target % ranking CY Letter Grades: Value Q X Growth R X Quality S x Moat T x Super Multiple Predictor X x Quality Trio EQ Short Interest FQ Short interest Ranking % FR Share repurchases GE Share repurchases ranking GF EV/Sales Trailing CM EV/Sales Trailing Ranking CN EV/Sales Forward CP EV/sales forward ranking CQ EV/EBITDA Trailing CR EV/EBITDA Trailing ranking CS EBTIDA/OCF FK EBITDA/OCF Rank FL EV/EBITDA Forward CT EV/EBITDA Forward Ranking CU EBITDA Margin DE EBITDA Margin Ranking DF Revenue Per Share DC FCF Margin Trailing AT FCF Margin Forward AU EV/FCF DA EV/FCF ranking DB Debt to Equity DJ Debt to Equity Ranking DK Altman Z Score FI Altman Z Score Ranking FJ Interest expense/FCF DV Interest expense/FCF% DW ROE ER ROE % Ranking ES ROIC EO ROIC % Ranking EP Cash Conversion cycle EU Cash Conversion cycle ranking EV DSO's EW DSO ranking EX Inventory Turnover EY Inventory Turnover Ranking EZ Research & Development/Sales FA R&D ranking FC Sales & Marketing/Sales FD Sales & Marketing/Sales ranking FF Gross Margin FG Gross Margin Ranking FH Price/Tangible Book FM Price/tangible book ranking FN Sell Side Revision 1 month change EBITDA GO 1 month change EBITDA ranking GP 1 month change in revenue GQ 1 month change in rev ranking GR Revenue Growth Rates 5 year trailing EG 5 year trailing rank EH 3 year trailing EE 3 year trailing rank EF 1 year trailing EB 1 year trailing ranking EC 1 year forward EI 1 year forward ranking EJ 2 year forward EK 2 year forward ranking EL Beta GJ Beta Ranking GK Stock based comp GL Stock based comp/Revenue ranking GM Stock Price 3 month FY 3 month ranking FZ 3 month SPY GA 6 month GB 6 month ranking GC 6 month SPY GD Share count growth 1 year DN 1 year ranking DO 3 year DQ 3 year ranking DR 5 year DT 5 year ranking DU