Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to work out bonuses
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to work out bonuses
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to work out bonuses
Or just
=(A1300)*0.1 -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Elkar" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to work out bonuses
"Sandy Mann" wrote in message
... "Elkar" wrote in message ... .... 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(A1300,A1*.1,0) Or just =(A1300)*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)) -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |