Solved round figers in excel

August 1, 2015 at 10:29:13
Specs: Windows 7
I like have formula which can total more than two or mothn five add .01 extra.

Like
in excel:
0.33+0.33=0.66 that's ok but
0.33+0.33+0.33=0.99 but I lke have 1.00
Same with 0.33+0.33+0.33+0.33+0.33=1.66 and 0.33+0.33+0.33+0.33+0.33+0.33 = 2.00

That means every third become auto .034 so it will give full figure like 1.00 , 2.00, 3.00


See More: round figers in excel

Report •


#1
August 1, 2015 at 10:45:57
✔ Best Answer
Excel will calculate "exactly". You can set the rounding in the results cells to be whatever you wish. Right click > Format cells > Number tab.

Always pop back and let us know the outcome - thanks

message edited by Derek


Report •

#2
August 1, 2015 at 12:54:27
it does help me but i figure it out different way.

Report •

Related Solutions


Ask Question