ExcelBanter - If then formula with multiple Ifs

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If then formula with multiple Ifs (https://www.excelbanter.com/excel-worksheet-functions/448594-if-then-formula-multiple-ifs.html)

R&I Guy

If then formula with multiple Ifs

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

Claus Busch

If then formula with multiple Ifs

Hi,

Am Fri, 12 Apr 2013 16:34:07 +0000 schrieb R&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

Mazzaropi

Quote:

Originally Posted by R&I Guy (Post 1611200)

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.

R&I Guy

Quote:

Originally Posted by Mazzaropi (Post 1611211)

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!

All times are GMT +1. The time now is 01:28 PM.