View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default need to work out bonuses

Yes, let's say your sales are in Column A. In Column B, use this formula to
display the amount of the bonus:

=IF(A1300,A1*.1,0)

HTH,
Elkar


"Grd" wrote:

Hi,

I have a column of sales figures and I need to determine if they qualify for
a bonus. Sales figures over 300 qualify for a bonus of 10%. Is it possible
to do this? Is there a function?


Any help would be appreciated.
Thanks,
Sandra