Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Halifax Bauer street
 
Posts: n/a
Default "IF" functions for Excel?

What site is best for learning to use "IF" functions in EXCEL???
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default "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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph
 
Posts: n/a
Default "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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default "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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you enter more than 7 "if" functions in a formula? Heindrich Excel Worksheet Functions 3 April 6th 06 04:10 PM
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) skye1971 Excel Worksheet Functions 1 February 1st 06 07:27 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
Visible rows and functions that work tracy Excel Worksheet Functions 2 August 19th 05 05:25 AM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"