Remember Me?

#1
January 27th 05, 01:51 AM
 Jake Posts: n/a
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
January 27th 05, 02:03 AM
 Naz Posts: n/a

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jroyv Excel Worksheet Functions 2 February 11th 05 07:07 PM Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 06:29 PM Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 02:07 PM Phill Barrett Excel Discussion (Misc queries) 4 January 5th 05 02:07 PM Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 18th 04 11:51 PM

All times are GMT +1. The time now is 03:10 AM.