Thread: if then
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default if then

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Jesper" wrote in message
...
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?