View Single Post
  #1   Report Post  
mmurray47 mmurray47 is offline
Junior Member
 
Posts: 1
Default Need IF Statement to yield percentages

Thanks -

Two Columns involved:

- Column F has text entries in the range F2:F28: (Ex: "Oranges" or "Apples")

- Column K has a general values in the range K2:K28 (Ex: "7.0.4" or "6.1.4")

I need a formula which will yield, for example, the percentage of:

- Oranges that are 7.0.4
- Apples that are 6.1.4 (obviously the difference but I need to display both).

The formulas can reside in two separate cells if necessary. Thanks again!