Don't know how to write the formula?

[jlawyer55]

Here is what I need to do. in the example below I need Colum L (Velocity Code) to have a formula that if Colum K (Hit Count) has a number >250 it puts an "A" in the Velocity Code Colum. But if it is <250 but >100 it puts a "B", if it is <100 but > 50 it puts a "C", <50 but > 10 it puts a D and <10 it puts an "E".

Any help would be appreciated.

 

[Scott Huish]

Are they whole numbers or are there decimal amounts?

If whole numbers, then:

=LOOKUP(K1,{0,11,51,101,251},{"E","D","C","B","A"})

 

[jlawyer55]

This is what the sheet looks like;

Business Unit	Short Item No	Sales Code	ROP	Mfg. Code	2nd Item Number	Description	Description Line 2	Primary Location	Total Quantity	Hit Count	Velocity Code
1100	2167437	2	939	HOS	798303CS	Sodium Chloride 0.9% 500ml BG	INJ 24/cs	K-01	3397	1564
1100	2211531	16	1273	3M	3M9640	Electrode Red Dot Adult LF	High Tack Adhesive 50/bx	H-14-A	4522	896
1100	2498316	11	2287	MY	742130EA	Dexamethasone 4mg/ml 30ml MDV		D-22	6009	150
1100	2495431	11	661	HOS	662902EA	Quelicin 20mg/ml 10ml	*Refrigerate*	RF-22	1688	802
1100	2495967	11	635	WW	600610EA	Atropine Sulfate 0.4mg/ml 20ml	MDV	D-22	1960	50
1100	2167357	2	445	HOS	795303CS	Lactated Ringer 500ml BG INJ	24/cs	K-03	1463	634
1100	2498412	11	561	APP	061603EA	Amiodarone 50mg/ml 3ml VL		D-22	2136	8

<colgroup><col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="64" style="width: 48pt;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="117" style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;"> <col width="235" style="width: 176pt; mso-width-source: userset; mso-width-alt: 8594;"> <col width="232" style="width: 174pt; mso-width-source: userset; mso-width-alt: 8484;"> <col width="204" style="width: 153pt; mso-width-source: userset; mso-width-alt: 7460;"> <col width="123" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;"> <tbody> </tbody>

 

[Scott Huish]

See my formula above your last post.

 

[jlawyer55]

Thank You very much