Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |