Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between the , use of functions and the use of formatting to round the numbers in Excel?

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2014/10/28
FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

When we use round functions,  the real value  changes

When we use  number format  the real value still and do not change 

 

For example 

 

Number value  2.353  

 

 

Using round function  +one digit   = round (2.353;1 ) =  2.4  real  result value =2.400

 

Using number format +one digit  =     be  showed    =  2.4   real  result value =2.353

 

 

 

Some times  : we get mistakes  becouse we did not care about  some detail

Mohammad Ali
by Mohammad Ali , Accounts Officer ( Contract) , Bharat Pumps & Compressors Ltd Naini Allahabad

use of formatting to round changes only view it not round up the figure. if you add2.538 (Formatting view2.54) but add2.538 while round(2.538,2) view2.54 but add2.54 

Johnny Anthony
by Johnny Anthony , Executive Secretary , Indusmens Corporation

Rounding numbers in Excel can be accomplished using a number of different functions depending on the results you want.

For example, the INT function can be used to round a number down to the next lowest integer while removing the decimal portion of a number.

Unlike formatting option that allow you change the number of decimal places displayed by your data, the INT function actual alters the data in your worksheets.

Using this function can, therefore, affect the results of calculations.

VENKITARAMAN KRISHNA MOORTHY VRINDAVAN
by VENKITARAMAN KRISHNA MOORTHY VRINDAVAN , Project Execution Manager & Accounts Manager , ALI INTERNATIONAL TRADING EST.

Mr. Fetah Mohamed.

I agree with your explanation.

Practically i have come across difficulty explained by you for an Inventory updation in the system using excel sheet for the template.

georgei assi
by georgei assi , مدير حسابات , المجموعة السورية

I agree with your answer completely brother Fattah

Mohamed Esam Mohamed Kamel
by Mohamed Esam Mohamed Kamel , Financial Analyst , Egyptian Water & Wastewater Regulatory Agency (EWRA)

I agree with you Fetah,

Formatting doesn't change values, only functions do.

Khaled Mohee Eldeen Abbas Mahmoud
by Khaled Mohee Eldeen Abbas Mahmoud , Chartered Accountant # 10465 , Self-employed

I agree with most of answers provided

MUHAMMAD SALEEM ANWAR
by MUHAMMAD SALEEM ANWAR , Accounts Exectutive , RAK GHANI GLASS LLC

By using Functions,  the real value  will be changed.

By using Format,  the real value will be same but shown without decimal

Nazia Zakir Ahmed
by Nazia Zakir Ahmed , Independent Consultant , Green Planet Services

functions will round off the numbers after digit and will change the value. formatting will only delete the numbers after the digit. 

More Questions Like This