View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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