Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

rounding formula help

0

my question is

(1) suppose a figure 123.55 in an Excel sheet A1, i want to set a formula in Excel sheet A2. for rounding off figure 0.45.

(2) When i changed sheet A1 figure then automatic change in A2 figure.

sum examle are given below showing when change the figure.

 Sheet A1 (amount)                             Sheet A2 (Round off amount)

     155.55                                                        +0.45

     205.60                                                        +0.40

     170.20                                                        -0.20 

      163.23                                                       -0.23

excelformulas-functions
MS Office Version: 2007
posted by: mithun (rep: 2) on Fri Aug 25, 2017 at 9:28 am
Post Edited
Title: Title was not descriptive.
Answer
Discuss

Answers

-1
Selected Answer

Please look at/look up the ROUND function in excel - it will give you good info on how to accomplish this.  But in cell A1 - copy this formula (Without the quotes) "=ROUND(A1,0)" to Cell A2.  Then copy the formula in A2 to the end of your data.

So Cell A2 shows "=ROUND(A1,0)"; B2 shows "=ROUND(B1,0)"; C2 shows "=ROUND(C1,0)";  etc. capiche?!

posted by: queue (rep: 467) on Fri Aug 25, 2017 at 11:00 am
Discuss

Discussion

ok but your meaning if in "sheet A1 amount 155.55 then showing round off amount 156 in sheet A2" acording to your formula, but i want if in sheet A1 155.55 then showing round of amount 0.45 in sheet A2.
mithun (rep: 2) Aug 26, '17 at 12:59 am
Then you have to use the formula which I suggested. The formula in this answer doesn't do what you want.
Variatus (rep: 4889) Aug 26, '17 at 2:26 am
Add to Discussion
0

Try this formula.

=ROUND(A1,0)-A1
posted by: Variatus (rep: 4889) on Fri Aug 25, 2017 at 10:14 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login