need to work out bonuses

[Guest]

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

 

[Guest]

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

=IF(A1>300,A1*.1,0)

HTH,
Elkar

 

[Guest]

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

 

[Sandy Mann]

Or just

=(A1>300)*0.1

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[David Biddulph]

....

Or just

=(A1>300)*0.1

All that will do, Sandy, is give an output of 0.1 if A1 is greater than 300.
I think Sandra may have wanted to work out the *amount* of the bonus.
If the bonus is 10% of the sales if the sales are over 300, then Elkar's
formula is right.
If the bonus is 10% of the amount by which the sales exceed 300, then use
=MAX(0,10%*(A1-300))