Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
=A1&"+"&A2&"+"&A3
NB: your formula could be =SUM(A1:A3) HTH -- AP "Dinesh" a écrit dans le message de news: ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
"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. Did you mean 65, not 45? (or did you intend the 10 to be -10, which might explain the reference to absolute, and makes the question different)? ... 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? -- David Biddulph |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
Hi David,
The answer is 65. To clarfy more, These numbers are linked to diff worksheet, so instead of going back to that link and see what is the absolute number is, I was wondering if you can toggle back and forth the furmula and see the absolute number or formula. Thanks. Dinesh "David Biddulph" wrote: "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. Did you mean 65, not 45? (or did you intend the 10 to be -10, which might explain the reference to absolute, and makes the question different)? ... 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? -- David Biddulph |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
One possible method even though a little tedious is
type the formula as if you would normally have done. Then press function key f2 and select each component of the formual and press function key F9 this will display the result press escape when done else it will overwrite the formula with absolute values "Dinesh" wrote in message ... Hi David, The answer is 65. To clarfy more, These numbers are linked to diff worksheet, so instead of going back to that link and see what is the absolute number is, I was wondering if you can toggle back and forth the furmula and see the absolute number or formula. Thanks. Dinesh "David Biddulph" wrote: "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. Did you mean 65, not 45? (or did you intend the 10 to be -10, which might explain the reference to absolute, and makes the question different)? ... 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? -- David Biddulph |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute function
Thanks. yes, very tedious if you have 10 combination.
"N Harkawat" wrote: One possible method even though a little tedious is type the formula as if you would normally have done. Then press function key f2 and select each component of the formual and press function key F9 this will display the result press escape when done else it will overwrite the formula with absolute values "Dinesh" wrote in message ... Hi David, The answer is 65. To clarfy more, These numbers are linked to diff worksheet, so instead of going back to that link and see what is the absolute number is, I was wondering if you can toggle back and forth the furmula and see the absolute number or formula. Thanks. Dinesh "David Biddulph" wrote: "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. Did you mean 65, not 45? (or did you intend the 10 to be -10, which might explain the reference to absolute, and makes the question different)? ... 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? -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |