 |
 | 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 2007Multiplying by Whole Numbers
I have a number in a cell that is the result of a formula. The number doesn't come out even such as 44.44 or 56.66 I need to use this number in another formula, but I want to use the whole number (44, 56) not the decimal version. Is there a way I can do that? Assuming source numbers in B2 down, you could use the integer part of it in C2 as eg: =INT(B2)  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- >I have a number in a cell that is the result of a formula. The number > doesn't come out even such as 44.44 or 56.66 [quoted text clipped - 3 lines] > > Is there a way I can do that? Thanks, this will work except I need one more thing. I need to round off the number I'm using first and then use that interger. For example, As a result of the formula I have 55.56 and 44.44. To go forward I want to multiply by 56 and 44. Is that possible? Thanks. >Assuming source numbers in B2 down, >you could use the integer part of it in C2 as eg: =INT(B2) =INT(ROUND(B2,0)) Gord Dibben MS Excel MVP >Thanks, this will work except I need one more thing. I need to round >off the number I'm using first and then use that interger. [quoted text clipped - 6 lines] >>Assuming source numbers in B2 down, >>you could use the integer part of it in C2 as eg: =INT(B2) Just use Round(). =Round(B2,0) Or =Round(your formula,0) SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Thanks, this will work except I need one more thing. I need to round > off the number I'm using first and then use that interger. [quoted text clipped - 6 lines] > >Assuming source numbers in B2 down, > >you could use the integer part of it in C2 as eg: =INT(B2) Too simple<g> Gord >Just use Round(). > >=Round(B2,0) >Or >=Round(your formula,0) I agree it's too simple. I entered "rounding off" into the help wizard and the "round" function didn't show up. If you just enter "round" it does. I guess they need a help file for the help file. Thanks again though, it's much appreciated. >Too simple<g> > [quoted text clipped - 5 lines] >>Or >>=Round(your formula,0) I enter "rounding off" into the help wizard and get 20 hits. The first hit is "round a number" which explains how to use the various ROUND functions. Hit 12 is "ROUND worksheet function" Gord >I agree it's too simple. I entered "rounding off" into the help >wizard and the "round" function didn't show up. If you just enter [quoted text clipped - 13 lines] >>>Or >>>=Round(your formula,0) I'm on an XL97 machine today, and didn't even get to the "... ing off" part! While typing "round" gave "Round Worksheet Function", And finishing with the ...ing, Gave "Rounding Numbers". BUT, I guess we all do know ... the older the version, the better the HELP files!<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I enter "rounding off" into the help wizard and get 20 hits. > [quoted text clipped - 22 lines] > >>>Or > >>>=Round(your formula,0) When I enter rounding off I get add a curve Mround worksheet function Int worksheet function remove one or more level of tracer arrows etc. etc. Nothing about rounding off or the round function. I'm not doubting you guys at all, that's just what I see. I'm using Office 2000. >I enter "rounding off" into the help wizard and get 20 hits. > [quoted text clipped - 22 lines] >>>>Or >>>>=Round(your formula,0) Ah so......... I am using 2003. Help is not consistent across versions. Now.....that's an understatement<g> Gord >When I enter rounding off I get > [quoted text clipped - 37 lines] >>>>>Or >>>>>=Round(your formula,0) On an XL02 machine this morning. The HELP index keyword box *doesn't* even allow me to type "rounding"! It stops at "round", And displays the 3 common round functions: Round() Roundup() Rounddown() So XL02 isn't too bad in this case. SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- Ah so......... I am using 2003. Help is not consistent across versions. Now.....that's an understatement<g> Gord >When I enter rounding off I get > [quoted text clipped - 47 lines] >>>>>Or >>>>>=Round(your formula,0) |
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.