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.