Excel "If" function

  • Thread starter Thread starter Charles Irani
  • Start date Start date
C

Charles Irani

I am trying to get detailed information on how to use "if"
fully. Even Microsoft Technical Help don't know what i'm
talking about. Where can i download full instructions on
its use and required syntax.
 
Hi Charles
what is missing for you in the Excel help file?. You may post what
you're exactly looking for as the general syntax is described in this
help?
 
If you type IF in the excel help it gives you a complete explanation

The syntax is:
IF(logical_test,value_if_true,value_if_false)

eg in cell B1 you want to return the words "Over budget" if the value in
cell A1 >100 and "On target" if the value in cell A1 < 100.
The formula in cell B1 would look like the following:

IF(A1>100,"Over budget","On target")

HTH
 
Try this Excel Dictionary courtesy of Peter Noneley,
http://homepage.ntlworld.com/noneley/
It explains things in plain English rather than the sometimes difficult to
follow Excel Help,
Regards
PS Its not a good idea to use a valid E-Mail address on here unless you're
ready for an avalanche of Spam!
 
Send Norman Harker an e-mail requesting his Excel
Functions help files. I found them very useful.
 
To me the use of the IF worksheet function in Excel is covere
adequately in Help.

However, if you are looking for more mathematical backgound informatio
I suggest an internet search on 'Boole', 'Boolean'.
or 'Boolean Mathematics'
 
Back
Top