Prev: convert text "20100315" to date format
Next: to find the repetitve text from a column.
From: GMv1 on 5 Apr 2010 08:04
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: Emece on 5 Apr 2010 08:13
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: Fred Smith on 5 Apr 2010 08:14
A little more information would have been useful, but you probably want
something like:
=IF(B5>=C5,"G",IF(B5>=D5,"Y","R"))

Regards
Fred

"GMv1" <GMv1(a)discussions.microsoft.com> wrote in message
news:5EBAA0C6-4E8A-4441-BF8A-49D7B2903D54(a)microsoft.com...
> 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:07
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: Bernard Liengme on 5 Apr 2010 09:17
Look at the last data value:60%
Now 'play computer" with =IF(B5=99.5%,"G",IF(B5<99.4%,"Y",IF(B5<98%,"R")))
1) 60% is not equal to 99.5 so we go to the next stage
2) 60% is les than 99.4% so we print Y and exit formula

Not try it with =IF(B5=99.5%,"G",IF(B5<98%,"R",IF(B5<99.4%,"Y")))
1) 60% is not equal to 99.5 so we go to the next stage
2) 60% is les than 98% so we print R and exit formula

It is important to do the test in the required order
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"GMv1" <GMv1(a)discussions.microsoft.com> wrote in message
news:095F1E64-2B32-44E9-9B9F-A82AF7804DC0(a)microsoft.com...
> 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!

 |  Next  |  Last
Pages: 1 2
Prev: convert text "20100315" to date format
Next: to find the repetitve text from a column.