How do I perform an IF function on Microsoft excel?

C

Chip Pearson

The syntax of the IF function is

=IF(test,result_if_true,result_if_false)

where test is a comparison or expression that returns TRUE (or a
non-zero number) or FALSE (or zero), and result_if_true is the
result to be returned if test is TRUE and result_if_false is the
result to be returned if test is FALSE. E,g,

=IF(A1>10,"greater","not greater")

This will return the text "greater" if A1>10, otherwise it will
return the text "not greater".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...
 
U

USAOz Services

What's the problem?

Basically, the function is composed of 4 parts - the function name prefaced
by the = sign, an open parentenese, a "test" condition (what 'question' of
which you are trying to determine the truth of falseness) followed by a comma
and then the action to perform if the 'question' is true, followed by a comma
then the action to perform if the 'question' is false, and finally a closing
parentheses.

a simple example:

You want to test if a number in a refernce cell is greatrer or equal to
another value in (say) a calculated cell.

Let's say you have the value 1000 in cell A1 and as a result of calculations
(lets say daily sales of a salesperson) you have a value of 1200. You have
decided to pay a 10% bonus of any amount over 1000 (cell A1) to any
salesperson exceeding your daily sales target. In this case the salesperson
would receive a bonus of $20.00

In cell A1 type 1000

In cell C2 (or wherever) enter the salesperson's daily sales (1200)
In cell D2 enter the function:

=IF(C2>A1,(c2-a1)*.2,"No bonus")

This means, test to see if C2 (salesperson's sales) is greater than the base
sales figure ($1000) and if it IS then find the amount by which it is
exceeded (Sales {C2} less base figure {A1}) and determine 20% of that
(multiply by .2). If the result of the test is less than or equal to $1000,
then display the text No bonus (note the use of the quoites in this
situation) - you can make the true/false actions anything you like.

Does that help?

D. Bruce
USAOz Services
 
Top