T
TaGY2K
How do you round down from excel ..
ie. 14.56 to 14
14.4 to 14
14.8 to 14
ie. 14.56 to 14
14.4 to 14
14.8 to 14
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Try
=ROUNDDOWN(A1,0)
=ROUNDDOWN(A1,0)
K
KL
=ROUNDDOWN(14.56,0)
=INT(14.56)
=FLOOR(14.56,1)
Regards,
KL
=INT(14.56)
=FLOOR(14.56,1)
Regards,
KL
D
Don Guillett
Look in HELP index for ROUND
C
comish4lif
=rounddown(14.56,0) where the ",0" rounds down to 0 decimal places.
You can also wrap this function around another calculation:
=rounddown(a1/b1,0)
You can also wrap this function around another calculation:
=rounddown(a1/b1,0)
R
Ron Coderre
Try this:
=ROUNDDOWN(A1,0)
(Rounds towards zero)
14.7>>>14
-1.8>>>-1
Does that help?
Ro
=ROUNDDOWN(A1,0)
(Rounds towards zero)
14.7>>>14
-1.8>>>-1
Does that help?
Ro