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
|