Another Newb question

marksv4

New Member
Joined
Nov 12, 2019
Messages
2
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!!
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,923
Office Version
2010
Platform
Windows
I think this should do it...

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

Watch MrExcel Video

Forum statistics

Threads
1,099,253
Messages
5,467,563
Members
406,543
Latest member
semoredhawk

This Week's Hot Topics

Top