Absolute function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Dinesh

=A1&"+"&A2&"+"&A3

Is that what you mean?

--
Kind regards,

Niek Otten

| 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
|
 
Dinesh said:
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.
Click to expand...

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)?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum number range ignoring numbers formatted as text 0
Formula for the calculation needed to come up with a total 5
Finding and copying whole rows 1
convert time to 1/4 hours 2
Absolute formulas 4
IF AND Nested Functions - Formula Not Working 0
Excel Subtracting multiple columns from another column 3
Function to add 3 column (of YES) to give a total % complete 7

Back
Top