software

I am trying to construct a formula that will take colum quot;b2quot; and determine if
it is greater than $100,000; if the formula is, I need to take the amount
that is greater than 100,000 and multiply it by .005, then add the 100,000 *
..00575.
I have been away from Excel for a year, and I know that it can be done, but
I'm too rusty and keep getting errors.
Any suggestions would be appreciated.
Thank you,
Pam

Try this, Pam:

=IF(B2gt;100000,(B2-100000)*0.005 100000*0.00575,B2*0.00575)

I have assumed that if B2 is less than or equal to 100,000 then you
would want to multiply it by .00575.

Hope this helps.

PeteOne way

=MAX(B2-100000,0)*0.005 MIN(100000,B2)*0.00575

to just get the values greater than 100000 use

=MAX(B2-100000,0)*0.005Regards,

Peo Sjoblom

quot;Pamquot; wrote:

gt; I am trying to construct a formula that will take colum quot;b2quot; and determine if
gt; it is greater than $100,000; if the formula is, I need to take the amount
gt; that is greater than 100,000 and multiply it by .005, then add the 100,000 *
gt; .00575.
gt; I have been away from Excel for a year, and I know that it can be done, but
gt; I'm too rusty and keep getting errors.
gt; Any suggestions would be appreciated.
gt; Thank you,
gt; Pam

If at all i understood right.....

=if(b2gt;100000,((b2*.005) (100000*.00575)))

see if it works.

GARY

quot;Pamquot; gt; wrote in message
...
gt;I am trying to construct a formula that will take colum quot;b2quot; and determine
gt;if
gt; it is greater than $100,000; if the formula is, I need to take the amount
gt; that is greater than 100,000 and multiply it by .005, then add the 100,000
gt; *
gt; .00575.
gt; I have been away from Excel for a year, and I know that it can be done,
gt; but
gt; I'm too rusty and keep getting errors.
gt; Any suggestions would be appreciated.
gt; Thank you,
gt; Pam
I used this function, but thanks Pete, your's works too, and I haven't tried
the min max yet, but will.
Thanks for all your help

=IF(H8lt;=100000,SUM(H8*0.00575),SUM(H8-100000)*(0.005) (575))

quot;Pamquot; wrote:

gt; I am trying to construct a formula that will take colum quot;b2quot; and determine if
gt; it is greater than $100,000; if the formula is, I need to take the amount
gt; that is greater than 100,000 and multiply it by .005, then add the 100,000 *
gt; .00575.
gt; I have been away from Excel for a year, and I know that it can be done, but
gt; I'm too rusty and keep getting errors.
gt; Any suggestions would be appreciated.
gt; Thank you,
gt; Pam

=if(b2gt;100000,((b2*.005) (100000*.00575)),quot;quot;)

forgot to put the Value If False. now try.

quot;Garyquot; gt; wrote in message
...
gt; If at all i understood right.....
gt;
gt; =if(b2gt;100000,((b2*.005) (100000*.00575)))
gt;
gt; see if it works.
gt;
gt; GARY
gt;
gt; quot;Pamquot; gt; wrote in message
gt; ...
gt;gt;I am trying to construct a formula that will take colum quot;b2quot; and determine
gt;gt;if
gt;gt; it is greater than $100,000; if the formula is, I need to take the amount
gt;gt; that is greater than 100,000 and multiply it by .005, then add the
gt;gt; 100,000 *
gt;gt; .00575.
gt;gt; I have been away from Excel for a year, and I know that it can be done,
gt;gt; but
gt;gt; I'm too rusty and keep getting errors.
gt;gt; Any suggestions would be appreciated.
gt;gt; Thank you,
gt;gt; Pam
gt;
gt;
Pam,
You do not need the SUM function he
Wrong: =IF(H8lt;=100000,SUM(H8*0.00575),SUM(H8-100000)*(0.005) (575))
Right: =IF(H8lt;=100000,(H8*0.00575),(H8-100000)*(0.005) (575))
or even:=IF(H8lt;=100000,H8*0.00575,(H8-100000)*0.005 575)

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
Thanks for feeding back, Pam.

Pete