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.00That means every third become auto .034 so it will give full figure like 1.00 , 2.00, 3.00

Excel will calculate "exactly". You can set the rounding in the results cells to be whatever you wish. Right click > Format cells > Number tab.

Alwayspop back and let us know the outcome - thanks

message edited by Derek

it does help me but i figure it out different way.

Ask Your Question

Weekly Poll