Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang |
#2
![]() |
|||
|
|||
![]() You can use the INT function. This 'rounds down' any number to the nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) returns 2 HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468209 |
#3
![]() |
|||
|
|||
![]()
You are correct. It is much easier to fix a formula and copy it than to
re-type piles of numbers. Say you have 123.456 in A1 and your formula looks like =A1+....... replace A1 with FIXED(A1,0) and copy it anywhre you want. -- Gary''s Student "Mustang" wrote: I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang |
#4
![]() |
|||
|
|||
![]()
To change a number as it's being used in a formula:
A1 = 10.25 B1 = 10 =A1*B1 Returns - 102.5 Revise to: =INT(A1)*B1 Returns - 100 To change the return of a formula: =INT(A1*B1) Returns - 102 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mustang" wrote in message ... I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang |
#5
![]() |
|||
|
|||
![]()
That worked! Thanks!!!!!
"Gary''s Student" wrote: You are correct. It is much easier to fix a formula and copy it than to re-type piles of numbers. Say you have 123.456 in A1 and your formula looks like =A1+....... replace A1 with FIXED(A1,0) and copy it anywhre you want. -- Gary''s Student "Mustang" wrote: I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang |
#6
![]() |
|||
|
|||
![]()
You *are* aware, that the return of the FIXED() function is *text*, and
*not* a number. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Mustang" wrote in message ... That worked! Thanks!!!!! "Gary''s Student" wrote: You are correct. It is much easier to fix a formula and copy it than to re-type piles of numbers. Say you have 123.456 in A1 and your formula looks like =A1+....... replace A1 with FIXED(A1,0) and copy it anywhre you want. -- Gary''s Student "Mustang" wrote: I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I delete multiple cells with decimal, not whole, numbers? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
Formula to calculate only the negative numbers | Excel Worksheet Functions |