On Tue, 06 Sep 2005 18:06:19 GMT, Poliisi wrote:
How can i create simple math function from chart location, which ignores
its decimal numbers?
Ie. A2 is "=1/2" and A1 is "=A2 * 2". I want the A1 function to display 0
as it would if the outcome from A2 is not rounded and the decimals are
simply dropped away.
A1: =INT(A2)*2
--ron
|