If your sales figure is in say F3, then where you want to calculate the
bonus, enter
=IF(F3300,F3*.1,0) or replace the 0 with ""

"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