formula to check multiple conditions

[belvy123]

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

 

[BoniM]

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?

 

[Vergel Adriano]

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")))

 

[belvy123]

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 K3>1
then display the value of this formula H7/K7

I hope that can be done
please help

 

[BoniM]

=IF(K3>1,H7/K7,IF(AND(K3>0,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 K3>1
then display the value of this formula H7/K7

I hope that can be done
please help

 

[belvy123]

Works perfectly
Thankyou oh so very much

 

[David Biddulph]

=IF(K3>1,H7/K7,IF(K3>0,H3,""))

You don't need to test for K3<=1, because you've already tested for K3>1
earlier.

 

[belvy123]

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(K3>1,H7/K7,IF(AND(K3>0,K3<=1),H3,""))
it is doing exactly what I was hoping for

Thanks
DN

 

[David Biddulph]

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 K3>1?

 

[BoniM]

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.