IF need to add a third value
 

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!

IF need to add a third value
 

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!

IF need to add a third value
 

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

IF need to add a third value
 

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!

IF need to add a third value
 

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!

IF need to add a third value
 

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

IF need to add a third value
 

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!