If then formula with multiple Ifs

[R&I Guy]

I stumbled across the forum while looking for an answer for this issue.

Thanks in advance, and looks like I will be spending alot of time o
this forum!

I want to use the if Then function, for:

I cell A1< A10 and A1< A15 and A1< A20 then, 1 for true and 0 fo
false.

Seems like it should be possible but can't get it to work.

Thank

 

[Claus Busch]

Hi,

Am Fri, 12 Apr 2013 16:34:07 +0000 schrieb R&amp;I Guy:

I cell A1< A10 and A1< A15 and A1< A20 then, 1 for true and 0 for
false.

try:
=A1=MIN(A1,A10,A15,A20)
or:
=--(A1=MIN(A1,A10,A15,A20))


Regards
Claus Busch

 

[R&I Guy]

Help from *Brazil*
Hi *R&I Guy*

Try to do like this:
=IF(AND([/B]A1<A10,A1<A15,A1<A20*)*,1,0

Tell me if it´s what you desire.

Have a nice day.

That is perfect! Thank you

 

[R&I Guy]

Help from *Brazil*
Hi *R&I Guy*

Try to do like this:
=IF(AND([/B]A1<A10,A1<A15,A1<A20*)*,1,0

Tell me if it´s what you desire.

Have a nice day.

That is perfect! Thank you