![]() |
round down?
=ROUNDDOWN(a1*0.84,0)
if you always want to round down or INT(A1*0.84) HTH "dbrumit" wrote: I want to take cell a1 wich has a value of 111 in it, and multiply that by .84. I would like the cell to then show 93 and not 93.24 If I format the cell to number and 0 decimal it will show 93 but in the formula bar it will show 93.24 Can this be done? Thanks |
All times are GMT +1. The time now is 11:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com