Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mustang
 
Posts: n/a
Default Formula without using numbers after decimal in the answer

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   Report Post  
swatsp0p
 
Posts: n/a
Default


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   Report Post  
Gary''s Student
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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   Report Post  
Mustang
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I delete multiple cells with decimal, not whole, numbers? Implicity Excel Worksheet Functions 2 June 11th 05 12:05 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 04:28 AM
Adding numbers in a column that have 3 decimal places KimberlyC Excel Worksheet Functions 4 April 24th 05 02:25 AM
How can I convert binary numbers to decimal when they are larger . Nebulae Excel Worksheet Functions 1 April 14th 05 06:50 PM
Formula to calculate only the negative numbers Dawn Boot-Bunston Excel Worksheet Functions 5 November 24th 04 10:57 PM


All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"