ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   simple excel formula (https://www.excelbanter.com/excel-discussion-misc-queries/137948-simple-excel-formula.html)

Paolo Orlando

simple excel formula
 
Hi everybody, I know it's pretty trivial, but I need your help. I just want
to have in the final calculation of an excel formula a value without
decimals. How can I insert the "decrease decimals" function or an equivalent
into the cells?


Gary''s Student

simple excel formula
 
Use the ROUND() Function:

if you were using something like :
=A1+B1
then use:
=ROUND(A1+B1,0)
--
Gary''s Student - gsnu200713


"Paolo Orlando" wrote:

Hi everybody, I know it's pretty trivial, but I need your help. I just want
to have in the final calculation of an excel formula a value without
decimals. How can I insert the "decrease decimals" function or an equivalent
into the cells?



All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com