formula
 

if the cell is less than $50,000 it needs to be * by 22% if the cell is
greater than $50,000 the first $50,000 needs* by 22% and everyting after by
10%. Please help I stuck.

formula
 

Try this:

=IF(A1<=50000,A1*0.22,50000*0.22+(A1-50000)*0.1)

Hope this helps.

Pete

On Jan 18, 12:32*am, jsp wrote:
if the cell is less than $50,000 it needs to be * by 22% if the cell is
greater than $50,000 the first $50,000 needs* by 22% and everyting after by
10%. Please help I stuck.

formula
 

try this where v4 is your cell value
=MIN(50000,V4)*0.22+IF(V450000,V4-50000)*0.1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jsp" wrote in message
...
if the cell is less than $50,000 it needs to be * by 22% if the cell is
greater than $50,000 the first $50,000 needs* by 22% and everyting after
by
10%. Please help I stuck.

formula
 

hi
try this. i use 100,000 as test. (=60,000 , 70,000 and 80,000)
50,000*.22 =11,000
50,000*.10= 5,000
total = 16,000
=IF(A1<=50000,A1*0.22,(50000*0.22)+(A1-50000)*0.1)

regards
FSt1

"jsp" wrote:

if the cell is less than $50,000 it needs to be * by 22% if the cell is
greater than $50,000 the first $50,000 needs* by 22% and everyting after by
10%. Please help I stuck.

formula
 

How would you do this manually? Perhaps the following? Amount is less than
or equal to 50000 then 50000 * 22 % and if amount is greater than 50000
then 50000 * 22% + (Amount - 50000) * 10%? Assuming the amount is in cell
A1 then

=IF(A1<=50000,A1*22%,50000*22%+(A1-50000)*10%)

Tyro

"jsp" wrote in message
...
if the cell is less than $50,000 it needs to be * by 22% if the cell is
greater than $50,000 the first $50,000 needs* by 22% and everyting after
by
10%. Please help I stuck.