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

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

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

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

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

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

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

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

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

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