ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Remove Decimal from Calculations (https://www.excelbanter.com/excel-discussion-misc-queries/10148-remove-decimal-calculations.html)

 Jake January 27th 05 01:51 AM

Remove Decimal from Calculations

Is there a way to multiply by a value in a cell, but only by the whole number?

So if a cell's value is 2.2143, and I multiply by another cell with a value
of 2, I want the result to be 4 (not rounded). Can this be done?

 Naz January 27th 05 02:03 AM

You can use the INT function. e.g

=Int(A1)+A2

Assuming 2.2143 is in A1 and 2 is in A2

Hope that helps

__________________
Naz
London

"Jake" wrote:

Is there a way to multiply by a value in a cell, but only by the whole number?

So if a cell's value is 2.2143, and I multiply by another cell with a value
of 2, I want the result to be 4 (not rounded). Can this be done?

 All times are GMT +1. The time now is 06:45 AM.