Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |