 |
 | 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 / Worksheet Functions / June 2007rounding of numeros
they forgive to put this formulates not this helping, We go to try galera debtor When I am rounding off the numeros, I have necessity that they are always in multiplos of 5 in 5.. What nao happens. sees... 0.401 well, 0,425, 0,435, 0,449 I have the necessity that they result in 0,450 for ai to be calculated A3 * b3 * 2.... = resulted normal already the data inceridos in the column and the B must be rounded off. A3 * B3 *C3= main digitaçao A3(0,401) * B3 (0,449) * C3 (2) = 0,2025 must be D3(0,450) * E3 (0,450) * F3 (2) = 0,2025 A4(0,832) * B4 (0,850) * C4 (2) = 0,7225 must be D4 (0,85) * E4 (0,85) * F4 (2) = 0,7225 Hi, I'm not sure what your question is but... What you probably need is =MROUND(A1,5) The is an Analysis ToolPak function - to add it choose Tools, Add-Ins, and check Analysis ToolPak.  SignatureCheers, Shane Devenshire > they forgive to put this formulates not this helping, We go to try galera > debtor [quoted text clipped - 12 lines] > A4(0,832) * B4 (0,850) * C4 (2) = 0,7225 must be > D4 (0,85) * E4 (0,85) * F4 (2) = 0,7225 With all due respect, I suggest you post in an Excel forum for your native language (if one exists). Biff > they forgive to put this formulates not this helping, We go to try galera > debtor [quoted text clipped - 13 lines] > A4(0,832) * B4 (0,850) * C4 (2) = 0,7225 must be > D4 (0,85) * E4 (0,85) * F4 (2) = 0,7225 Hi Try =CEILING(A3,0.05)*CEILING(B3,0.05)*CEILING(C3,0.05) This results in 0.405 Your formula was giving the result for C3 =1 which would be 0.2025 If you want 1 to be used as the final term regardless of what value is displayed in column C, then =CEILING(A3,0.05)*CEILING(B3,0.05)*MIN(C3,1) SignatureRegards Roger Govier > they forgive to put this formulates not this helping, We go to try > galera [quoted text clipped - 16 lines] > A4(0,832) * B4 (0,850) * C4 (2) = 0,7225 must be > D4 (0,85) * E4 (0,85) * F4 (2) = 0,7225 |
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.