IF & OR 1

[CCNProjects]

Hello.

I would like to point out the cell value under a certain condition: if cell A1 or cell A2 is greater than 0.001, then write the greatest value of A1 and A2 in cell A3.

=IF((A1>=0.001) OR (A2>=0.001), MAX(A1,A2),"")??????

Thanks for any hint.

 

[SkipVought]

Hi,

In Excel, OR is a FUNCTION, not an OPERATOR...
[tt]
=IF(OR((A1>=0.001),(A2>=0.001)), MAX(A1,A2),"")
[/tt]


Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[CCNProjects]

That was great! Thanks.