Need help with a % or $ value formula for excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to come up with a formula for a spreadsheet that I am creating. What
I am needing help on is this- i have a total value for a product and the
mark up is either 6% or $4500 which ever is greater. How would I do that?
D33 is my total cost value and D35 is the box I need this formula for.
PLEASE HELP!!
 
Oops

Why the "Oops"?
=IF(D33*0.06<4500,D33+4500,D33+(0.06*D33))
Click to expand...

Here is a shorter alternative...

=D33+MAX(4500,0.06*D33)

Rick
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
Need help with vlookup & MACRO 1
Need help with formulas 1
Convert A Formula to Value Until A Value is Met 1
Combining Text based on Values 8
Formula appearing as Value in Formula Bar 1
Excel Formula or equation 3
Sum Function When Formula Produces #N/A 2

Back
Top