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

Try this:

=IF(G8=30,"G",IF(G8=25,"S",""))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Swtmelly" wrote in message
...
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