need to work out bonuses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 19 May 2006 19:59 GMT

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

Reply to this Message

Elkar - 19 May 2006 20:08 GMT

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

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks,
> Sandra

Reply to this Message

Sandy Mann - 19 May 2006 20:22 GMT

Or just

=(A1>300)*0.1

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Yes, let's say your sales are in Column A. In Column B, use this formula
> to
[quoted text clipped - 16 lines]
>> Thanks,
>> Sandra

Reply to this Message

David Biddulph - 19 May 2006 20:59 GMT

...

>>> 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?

>> 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)

> 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))

Signature

David Biddulph

Reply to this Message

kassie - 19 May 2006 20:11 GMT

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 ""

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks,
> Sandra

Reply to this Message