help please..

[Lyrad13]

hi everyone, just wanted to know how to answer this in If function. newbie here.


Level 1 = below 20 percent
Level 2 = below 30 percent
Level 3 = above 50 percent
Level 4 = above 80 percent



Agent Average Service Level
John Smith 11% ?

Charles Steward 95% ?

Amanda Sykes 85% ?


TIA

 

[T. Valko]

hi everyone, just wanted to know how to answer this in If function. newbie here.


Level 1 = below 20 percent
Level 2 = below 30 percent
Level 3 = above 50 percent
Level 4 = above 80 percent



Agent Average Service Level
John Smith 11% ?

Charles Steward 95% ?

Amanda Sykes 85% ?


TIA

You have an undefined range.

>=30 and <=50

 

[vds1]

Lets Say A1 Has percentage then in B1 Paste this formula,

=IF(A1<0.2,"Level1",IF(A1<0.3,"Level2",IF(A1>0.8,"Level4",IF(A1>0.5,"Level3","No Level"))))

 

[jasonb75]

As already mentioned you have an undefined range, once that is defined you could use something like

Sheet8

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 116px"><COL style="WIDTH: 144px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Agent</TD><TD>Average Service Level</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">John Smith</TD><TD style="TEXT-ALIGN: right">11%</TD><TD>Level 1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Charles Steward</TD><TD style="TEXT-ALIGN: right">95%</TD><TD>Level 4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Amanda Sykes</TD><TD style="TEXT-ALIGN: right">85%</TD><TD>Level 4</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C2</TD><TD>=IF(B2,"Level "&MATCH(B2,{0,0.2,0.5,0.8}),"")</TD></TR><TR><TD>C3</TD><TD>=IF(B3,"Level "&MATCH(B3,{0,0.2,0.5,0.8}),"")</TD></TR><TR><TD>C4</TD><TD>=IF(B4,"Level "&MATCH(B4,{0,0.2,0.5,0.8}),"")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[Lyrad13]

thanks for quick response, much appreciated! i'll try those examples..