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

Hi Swtmelly,

Use following formula in G9:-

=IF(AND((G8)=25,G8<=29),"S",IF(G8=30,"G","Servic e Years are less than 25"))

Thanks & Best Regards,
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Swtmelly" wrote:

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

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

"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

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

=LOOKUP(G8,{0,25,30},{"","S","G"})


"Swtmelly" wrote:

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