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(C2A1,(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?