H
Halifax Bauer street
What site is best for learning to use "IF" functions in EXCEL???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
D
David Biddulph
Halifax Bauer street said:What site is best for learning to use "IF" functions in EXCEL???
You could start with Excel's own help.
C
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
[email protected]> wrote in message
news:[email protected]...
=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
[email protected]> wrote in message
news:[email protected]...