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 on 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 for false.

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

Thanks

Help from Brazil
Hi R&I Guy

Try to do like this:
=IF(AND(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!

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2