openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: Array formulas: maximum value – two conditions
Date Sat, 01 Jun 2013 05:50:08 GMT
At 08:18 01/06/2013 +0530, Kadal Amutham wrote:
>The IF statement will expect a condition to test, not and another AND.

Sorry, but by itself this is simply untrue, so cannot be the answer 
to the problem.  The first argument of the IF() function needs to be 
a logical expression; its value - TRUE or FALSE - determines which of 
the other two arguments is used.  That expression may often be a 
simple test, but the result of an AND() function is just as acceptable to IF().

I trust this helps.

Brian Barker

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message