software

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,
SandraYes, let's say your sales are in Column A. In Column B, use this formula to
display the amount of the bonus:

=IF(A1gt;300,A1*.1,0)

HTH,
Elkarquot;Grdquot; wrote:

gt; Hi,
gt;
gt; I have a column of sales figures and I need to determine if they qualify for
gt; a bonus. Sales figures over 300 qualify for a bonus of 10%. Is it possible
gt; to do this? Is there a function?
gt;
gt;
gt; Any help would be appreciated.
gt; Thanks,
gt; Sandra
gt;

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

quot;Grdquot; wrote:

gt; Hi,
gt;
gt; I have a column of sales figures and I need to determine if they qualify for
gt; a bonus. Sales figures over 300 qualify for a bonus of 10%. Is it possible
gt; to do this? Is there a function?
gt;
gt;
gt; Any help would be appreciated.
gt; Thanks,
gt; Sandra
gt;

Or just

=(A1gt;300)*0.1

--
HTH

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.ukquot;Elkarquot; gt; wrote in message
news
gt; Yes, let's say your sales are in Column A. In Column B, use this formula
gt; to
gt; display the amount of the bonus:
gt;
gt; =IF(A1gt;300,A1*.1,0)
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Grdquot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; I have a column of sales figures and I need to determine if they qualify
gt;gt; for
gt;gt; a bonus. Sales figures over 300 qualify for a bonus of 10%. Is it
gt;gt; possible
gt;gt; to do this? Is there a function?
gt;gt;
gt;gt;
gt;gt; Any help would be appreciated.
gt;gt; Thanks,
gt;gt; Sandra
gt;gt;
quot;Sandy Mannquot; gt; wrote in message
...

gt; quot;Elkarquot; gt; wrote in message
gt; news

....
gt;gt;gt; I have a column of sales figures and I need to determine if they qualify
gt;gt;gt; for
gt;gt;gt; a bonus. Sales figures over 300 qualify for a bonus of 10%. Is it
gt;gt;gt; possible
gt;gt;gt; to do this? Is there a function?

gt;gt; Yes, let's say your sales are in Column A. In Column B, use this formula
gt;gt; to
gt;gt; display the amount of the bonus:
gt;gt;
gt;gt; =IF(A1gt;300,A1*.1,0)

gt; Or just
gt;
gt; =(A1gt;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))
--
David Biddulph