Prev: convert text "20100315" to date format
Next: to find the repetitve text from a column.
From: Eduardo on 5 Apr 2010 09:17
Hi,
try

=IF(B5=0.995,"G",IF(AND(B5<0.994,B5>=0.98),"Y",IF(B5<0.98,"R")))

"GMv1" wrote:

> Thanks, I tried that and it is not working, here is what I have done. I get
> the "G" and the "Y" but no "R".
>
> Actual Target G/Y/R
> 100.00% 99.90% G
> 97.63% 99.50% Y
> 60.00% 94.50% R
>
> =IF(B5=99.5%,"G",IF(B5<99.4%,"Y",IF(B5<98%,"R")))
>
> 97.63% is cell B5
>
>
>
>
> "Emece" wrote:
>
> > Hi,
> >
> > You can use as many if() functions as needed.
> >
> > For example, =If(B5>=C5,"G",If(B5>=D5,"R",....,"Y")) and so on.
> >
> > Hope this helps
> >
> > Regards,
> > Emece.-
> >
> > "GMv1" wrote:
> >
> > > my formula is =IF(B5>=C5,"G","Y") I really need to add a third value of "R"
> > > if the logical test exceeds a value beyond what is in the current formula.
> > > Thanks in advance for your assistance!
From: GMv1 on 5 Apr 2010 09:40
This worked Thanks!

As a side note this forum has been very helpful to me over the last few
weeks and I just want to thank everyone for all of their assistance!

"Eduardo" wrote:

> Hi,
> try
>
> =IF(B5=0.995,"G",IF(AND(B5<0.994,B5>=0.98),"Y",IF(B5<0.98,"R")))
>
> "GMv1" wrote:
>
> > Thanks, I tried that and it is not working, here is what I have done. I get
> > the "G" and the "Y" but no "R".
> >
> > Actual Target G/Y/R
> > 100.00% 99.90% G
> > 97.63% 99.50% Y
> > 60.00% 94.50% R
> >
> > =IF(B5=99.5%,"G",IF(B5<99.4%,"Y",IF(B5<98%,"R")))
> >
> > 97.63% is cell B5
> >
> >
> >
> >
> > "Emece" wrote:
> >
> > > Hi,
> > >
> > > You can use as many if() functions as needed.
> > >
> > > For example, =If(B5>=C5,"G",If(B5>=D5,"R",....,"Y")) and so on.
> > >
> > > Hope this helps
> > >
> > > Regards,
> > > Emece.-
> > >
> > > "GMv1" wrote:
> > >
> > > > my formula is =IF(B5>=C5,"G","Y") I really need to add a third value of "R"
> > > > if the logical test exceeds a value beyond what is in the current formula.
> > > > Thanks in advance for your assistance!
First  |  Prev  | 
Pages: 1 2
Prev: convert text "20100315" to date format
Next: to find the repetitve text from a column.