Quote:
Originally Posted by 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 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.
__________________
I hope it can help you.
Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
|