Thread: Need help with a % or $ value formula for excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Patrick Dave Patrick is offline
external usenet poster
  
Posts: 249
Default 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!!

Reply With QuoteReply With Quote