Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|