Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" functions for Excel?
What site is best for learning to use "IF" functions in EXCEL???
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you enter more than 7 "if" functions in a formula? | Excel Worksheet Functions | |||
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) | Excel Worksheet Functions | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions |