Need help with a % or $ value formula for excel
 

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!!

Need help with a % or $ value formula for excel
 

=IF(D33*0.064500,D33+4500,D33+0.06*D33)

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Chris" wrote:
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!!

Need help with a % or $ value formula for excel
 

Oops

=IF(D33*0.06<4500,D33+4500,D33+(0.06*D33))

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Need help with a % or $ value formula for excel
 

Dave,
THANK YOU!!


"Dave Patrick" wrote:

Oops

=IF(D33*0.06<4500,D33+4500,D33+(0.06*D33))

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Need help with a % or $ value formula for excel
 

You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Chris" wrote:
Dave,
THANK YOU!!

Need help with a % or $ value formula for excel
 

Oops

Why the "Oops"?

=IF(D33*0.06<4500,D33+4500,D33+(0.06*D33))

Here is a shorter alternative...

=D33+MAX(4500,0.06*D33)

Rick

Need help with a % or $ value formula for excel
 

I canceled the "oops"

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect