 |
 | 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 / November 2006Is the syntax correct?
Is this syntax correct: =ROUNDUP((I35+I38),2) (need ROUNDUP sum.) What's in I35 and I38? What result do you get when you enter the formula in a cell? What result do you want? Gord Dibben MS Excel MVP >Is this syntax correct: > > =ROUNDUP((I35+I38),2) > >(need ROUNDUP sum.) > What's in I35 and I38? > [quoted text clipped - 9 lines] >> >>(need ROUNDUP sum.) ---------------------------- That is Invoice calculation. I35 column formula is: =SUM(I23:I34) -> data is 607.37 I38 column formula is: =I35*0.18 -> data is 109.33 I39 column formula is(this is total sum): =(I35+I38) -> but show wrong sum: 716.99 (must be 716.70, however). So i want roundup. Thanks. What do you see in the formula bar when you increase the decimal places in I35 and I38? I suspect you do not have exactly 607.37 and 109.33 and that is why you are getting what you think is an incorrect result of 716.99, which I think is a typo and you maybe meant 716.69 Try =ROUND(I35+I38,1) Gord >> What's in I35 and I38? >> [quoted text clipped - 19 lines] > >Thanks. > What do you see in the formula bar when you increase the decimal places in > I35 > and I38? > I suspect you do not have exactly 607.37 and 109.33 and that is why you > are > getting what you think is an incorrect result of 716.99, which I think is > a typo > and you maybe meant 716.69 > Try =ROUND(I35+I38,1) > Gord ------------------------------------ > What's in I35 and I38? > What result do you get when you enter the formula in a cell? > What result do you want? > Gord Dibben MS Excel MVP Is this syntax correct: =ROUNDUP((I35+I38),2) (need ROUNDUP sum.) ---------------------------- >>That is Invoice calculation. >>I35 column formula is: =SUM(I23:I34) -> data is 607.37 [quoted text clipped - 5 lines] >> >>Thanks. ----------------- When I increase the decimal places in I35 and I38, the formula does not change, numbers change in I35 -> 607.366 and in I38 -> 109.326. Yes, I meant 716.69 K. > > What do you see in the formula bar when you increase the decimal places in > > I35 [quoted text clipped - 41 lines] > > K. --------- Any ideas about this issue? I want minimize possible errors and failures in the further. K.
|
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.