Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Hi All
I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank?
Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Hi,
What do you want to show if none of the 2 conditions are satisfied? Or what if both conditions were satisfied? =IF(K3<=1, H3, IF(E3="", "", "UNKNOWN")) In the above, J3 will show "UNKNOWN" if none of the 2 conditions are satisfied. And now, here's one that will show "BOTH CONDITIONS SATISFIED" if both conditions are true: =IF(AND(K3<=1, E3=""), "BOTH CONDITIONS SATISFIED", IF(K3<=1, H3, IF(E3="", "", "UNKNOWN"))) -- Hope that helps. Vergel Adriano "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Hi Again
Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
=IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,""))
"belvy123" wrote: Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Works perfectly
Thankyou oh so very much :) -- cruchnin numbers "BoniM" wrote: =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) "belvy123" wrote: Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
=IF(K31,H7/K7,IF(K30,H3,""))
You don't need to test for K3<=1, because you've already tested for K31 earlier. -- David Biddulph "BoniM" wrote in message ... =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
Hello
I believe I do need that because I am wanting to do one thing if K3 is 0 but <=1 and another if K3 is 1 If I am thinking this out right And in using this formula =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) it is doing exactly what I was hoping for Thanks DN -- cruchnin numbers "David Biddulph" wrote: =IF(K31,H7/K7,IF(K30,H3,"")) You don't need to test for K3<=1, because you've already tested for K31 earlier. -- David Biddulph "BoniM" wrote in message ... =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
So what extra functionality do you think that the AND(...K3<=1) is giving
you? How are you going to get to that test if K31? -- David Biddulph "belvy123" wrote in message ... Hello I believe I do need that because I am wanting to do one thing if K3 is 0 but <=1 and another if K3 is 1 If I am thinking this out right And in using this formula =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) it is doing exactly what I was hoping for Thanks DN "David Biddulph" wrote: =IF(K31,H7/K7,IF(K30,H3,"")) You don't need to test for K3<=1, because you've already tested for K31 earlier. -- David Biddulph "BoniM" wrote in message ... =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to check multiple conditions
You are so right... I probably shouldn't answer questions in the wee hours of
the morning if I can let something that obvious get by. Thanks for the catch. "David Biddulph" wrote: =IF(K31,H7/K7,IF(K30,H3,"")) You don't need to test for K3<=1, because you've already tested for K31 earlier. -- David Biddulph "BoniM" wrote in message ... =IF(K31,H7/K7,IF(AND(K30,K3<=1),H3,"")) Hi Again Let me try this another way Can we do it like this If K3 0 and <=1 then display the value of H3 in J3 other wise if those conditions are not met then display nothing in J3 and if the value of K31 then display the value of this formula H7/K7 I hope that can be done please help -- cruchnin numbers "BoniM" wrote: Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank? Do you want J3 to display H3 or blank? "belvy123" wrote: Hi All I have a sheet where I want to be able to check 2 conditions tyo achieve the proper result -- here is my example if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank cell then I want to display a blank cell in J3 I am sure this is simple but I cant figure it out Thanks Dan N crunchnin numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple conditions formula | Excel Worksheet Functions | |||
MULTIPLE CONDITIONS FORMULA | Excel Discussion (Misc queries) | |||
How do I add multiple conditions to a formula? | Excel Worksheet Functions | |||
Need help on formula with multiple conditions... | Excel Discussion (Misc queries) | |||
Formula for multiple conditions | Excel Discussion (Misc queries) |