M
Mustard Head
Thanks, I'll try and explain a bit better
If you want to show the result of a formula and text in the same cel
you can use something like this =SUM(A1:A4)&"*".
This will sum the A1:A4, show the result and put an asterix at the en
of the number.(eg 22*)
But the problem occurs when the sum has decimal points. If the forma
is set to 2 decimal points but the sum is greater than 2 decimal point
then it does not round it to 2. It shows as 22.444444444444444* when i
should be 22.44*
It is like the tip "Joining text with a linked date in Microsof
Excel"
If you want to show the result of a formula and text in the same cel
you can use something like this =SUM(A1:A4)&"*".
This will sum the A1:A4, show the result and put an asterix at the en
of the number.(eg 22*)
But the problem occurs when the sum has decimal points. If the forma
is set to 2 decimal points but the sum is greater than 2 decimal point
then it does not round it to 2. It shows as 22.444444444444444* when i
should be 22.44*
It is like the tip "Joining text with a linked date in Microsof
Excel"