if then

[Guest]

Hi

I am setting up a chart for an employe.

The employe will get a bonus if he is passing a amount of sale.
ex: if selling for more than 500000 the he get 5000,- in a bonus

How can i set this up?

 

[Bob Phillips]

Look at VLOOKUP in help, it should get you started.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

You can set up a conditional if function. For example,

cell A1: Amount sold, cell B1: Bonus;
cell B1: enter the amount of good sold, cell B2 = if(B1>500000,5000,0)
cell B2 is saying that if the amount entered in B1 is greater than 500000,
then the bonus will be 5000. Otherwise, it is 0.

Alternatively, if the amount of bonus varies with the amount of good sold,
use lookup for more flexibility.