Re: Array formulas: maximum value – two conditions

[Brian Barker <b....@btinternet.com>]

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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org