M
Mustard Head
Cheers for that. Its a work around but invloves doing a sum in 1 cel
and then having a cell thats looks at the answer and adds a *.
Surely it should be able to limit the number of decimals just using th
one formula =SUM(A1:A4,"0.00")&"*"
Try it and see.
sum that equals 22.44444444444 is 22.4 without the &"*" an
22.44444444444 with &"*
and then having a cell thats looks at the answer and adds a *.
Surely it should be able to limit the number of decimals just using th
one formula =SUM(A1:A4,"0.00")&"*"
Try it and see.
sum that equals 22.44444444444 is 22.4 without the &"*" an
22.44444444444 with &"*