"IF" functions for Excel?

[Guest]

What site is best for learning to use "IF" functions in EXCEL???

 

[Gord Dibben]

There is only one "IF" function so I assume you mean Excel Functions in general
in combination with the "IF" function.

Peter Nonely has a function dictionary, available from Rod de
Bruin's site, at http://www.rondebruin.nl/files/xlfdic01.zip .


Gord Dibben MS Excel MVP

On Thu, 15 Jun 2006 14:09:02 -0700, Halifax Bauer street <Halifax Bauer

 

[David Biddulph]

What site is best for learning to use "IF" functions in EXCEL???

You could start with Excel's own help.

 

[Chip Pearson]

There isn't much to learn about IF. The syntax is

=IF(test,result_if_true,result_if_false)

where test is any expression or cell value that returns a numeric
or Boolean result. If test is TRUE or non-zero, IF returns
result_if_true. Otherwise, it returns result_if_false. Both
result_if_true and result_if_false can be anything you want.
E.g.,

=IF(A1>10,"Greater","Not Greater")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Halifax Bauer street" <Halifax Bauer
(e-mail address removed)> wrote in message
news:[email protected]...