How do I set up a min and max function in the same caluclation?

G

Guest

I want to do a state payroll calculation where the tax is calculated by
applying the tax rate to the base wage minus X percent of the base wage, with
a minimum and maximum amount. I am not sure how to write the formula with a
min and max amount.
 
B

Bob Phillips

With
A1: wage
B1: minus wage percentage
C1: tax rate
D1: minimum
E1: maximum

=MAX(MIN((A1-(A1*B1)*1)*C1,E1),D1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Calculating Max & Min in a negative numbes 6
conditions and the max function 1
How do I setup a formula for payroll deductions in excel 1
How do I get data automatically entered into a cell? 1
CHALLENGE! - USING IF MAX MIN AND LOOKUP TOGETHER 9
How do I reference the cell which returned a lookup value? 1
How do I figure out a pre-tax amount when I know the final total? 4

Top