software

=IF(A1,quot;Truequot;,quot;Falsequot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;buffquot; gt; wrote in message
news
gt;
quot;buffquot; gt; wrote:
gt; Subject: how to use true or false conditions.

(Sigh, I cannot post a reply to original article.)

Netiquette commentary: A subject line alone is rarely sufficient to
ask a question. Yours is a good example. You should add some
text to explain your question (see speculation below). There are
other reasons to repeat your question, at a minimum, in the body
of your posting.

I think the question you are asking is a fundamental one: how
would you use the true and false parts (not quot;conditionsquot;) of an
IF() function?

If that is you question, consider the following example. In C1,
you want one of the following values: if A1 is less than B1, then
D1; otherwise if A1 is not less than B1, then E1. That can be
written:

=if(A1 lt; B1, D1, E1)

HTH.