Excel problem

[tootricky]

Originally Posted by colinicky

Do I apply the round function to the column or the end cell ?

Originally Posted by tootricky

={SUM(ROUND(A1:A4,2))}

or something like that. To get the {} press Ctrl+Shift+Enter once you have entered the formula. This is a range formula.

Cheers/Nic

Ever get the feeling you are talking to yourself

[colinicky]

Thanks to tootricky for the idea but thanks to Si as his one actually works !