Absolute function
Hi Dinesh
=A1&"+"&A2&"+"&A3
Is that what you mean?
--
Kind regards,
Niek Otten
"Dinesh" wrote in message ...
| Hi,
|
| I am looking for a formula which can convert formula into absolute number
| not as a Total answer but adding the each number seperately.
|
| Example
| Col A
| 10
| 25
| 30
|
| Formula is =a1+a2+a3..So the answer would be 45. But I like to see the
| answer as=10+25+30 or conver the formula into abolute number by addition of
| each number rather than total.
|
| Is there a way to conver this?
|
| Thanks for the help.
|
| Dinesh
|
|