Can anybody tell me how I perform this fuction please?
Can anybody tell me how I perform this fuction please?
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
"katlawlor" <katlawlor@discussions.microsoft.com> wrote in
message
news:887BF377-C3B0-414E-9B8A-DD3AB60FBC35@microsoft.com...
> Can anybody tell me how I perform this fuction please?
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
"katlawlor" wrote:
> Can anybody tell me how I perform this fuction please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks