- **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*)

Remove Decimal from CalculationsIs 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? |

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. |

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.

ExcelBanter.com