Excel "If" function

[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.

 

[Frank Kabel]

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?

 

[Newbie]

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

 

[Alan]

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!

 

[GerryK]

Send Norman Harker an e-mail requesting his Excel
Functions help files. I found them very useful.

 

[BrianB]

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'