ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "IF" functions for Excel? (https://www.excelbanter.com/excel-worksheet-functions/94305-if-functions-excel.html)

Halifax Bauer street

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

Gord Dibben

"IF" functions for Excel?
 
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
wrote:

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



David Biddulph

"IF" functions for Excel?
 
"Halifax Bauer street" <Halifax Bauer
wrote in message ...
What site is best for learning to use "IF" functions in EXCEL???


You could start with Excel's own help.
--
David Biddulph



Chip Pearson

"IF" functions for Excel?
 
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(A110,"Greater","Not Greater")


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




"Halifax Bauer street" <Halifax Bauer
wrote in message
...
What site is best for learning to use "IF" functions in
EXCEL???





All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com