"IF" functions for Excel?
What site is best for learning to use "IF" functions in EXCEL???
|
"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??? |
"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 |
"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