formula

[jsp]

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.

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Don Guillett]

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

 

[FSt1]

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

 

[Tyro]

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