Function to ignore decimals

P

Poliisi

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

Ron Rosenfeld

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.
Click to expand...

A1: =INT(A2)*2


--ron
 
Top