 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008rounding up and down formulas
I am creating a retail price for our items. Problem is that I want the retail price to end in either a .49 or .99. Example when I figure my retail pricing off my cost it may come out to $6.74 and I would like to have a formula so that it would automatically come out to $6.99 or if it was to $6.49 if is was a lower number. Thanks! Try this: A1 = 6.74 =CEILING(A1+0.01,0.5)-0.01  SignatureBiff Microsoft Excel MVP >I am creating a retail price for our items. Problem is that I want the >retail [quoted text clipped - 4 lines] > was > a lower number. Thanks! Kris -- Here's one approach: A B 1 number =CEILING(A1,0.5)-0.01 HTH > I am creating a retail price for our items. Problem is that I want the retail > price to end in either a .49 or .99. Example when I figure my retail pricing > off my cost it may come out to $6.74 and I would like to have a formula so > that it would automatically come out to $6.99 or if it was to $6.49 if is was > a lower number. Thanks! That formula will *round down* an integer and a decimal = to 0.5 A1 = 10 A1 = 1.5 Formula result = 9.99 Formula result = 1.49 SignatureBiff Microsoft Excel MVP > Kris -- > [quoted text clipped - 14 lines] >> was >> a lower number. Thanks! Hi Kris, Where you say, > that it would automatically come out to $6.99 or if it was to $6.49 if is > was > a lower number. Thanks! Do you mean you want it to round like this 6.74 or lower - round down to 6.49 6.75 and higher.- round up to 6.99 If that is the case try this, =ROUND(A1/0.5,0)*0.5-0.01 HTH Martin >I am creating a retail price for our items. Problem is that I want the >retail [quoted text clipped - 4 lines] > was > a lower number. Thanks! That is kind of confusing. I read it to mean: .00 to .49 = round to .49 .50 to .99 = round to .99 SignatureBiff Microsoft Excel MVP > Hi Kris, > [quoted text clipped - 22 lines] >> was >> a lower number. Thanks!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.