View Single Post
  #1   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???