View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Swtmelly Swtmelly is offline
external usenet poster
 
Posts: 3
Default If Formula confusion

Good Morning, I need help with the following:

Gold pins go to employees with 30+ years, silver pins to employees with 25 -
29 years. I can't figure out how to comine the IF formulas to return a G or
an S

Example - Joe has 27 years experience, 27 is in cell G8 in G9 need an S to
appear.

Mary has 31 years experience, need G to appear.

Thanks