Another Newb question

[marksv4]

Column A, cells A1, A2 etc have values in it. i.e.
525000
675000
etc.
In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount

I.E
525,000, 7% of 100,000 plus 2.5% of 425,000
675,000, 7% of the first 100,000 plus 2.5% of 575,000


I can do it in two columns but am unsure of the complete formula for getting the answer in B1, B2 etc.


Thanks everyone!!

 

[Rick Rothstein]

I think this should do it...

=0.07*MIN(100000,A1)+0.025*MAX(0,A1-100000)

 

[marksv4]

I think this should do it...

=0.07*MIN(100000,A1)+0.025*MAX(0,A1-100000)

Thanks very much Rick, much appreciated