Absolute function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dinesh - 18 May 2006 07:04 GMT

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

Reply to this Message

Niek Otten - 18 May 2006 07:12 GMT

Hi Dinesh

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

Is that what you mean?

Signature

Kind regards,

Niek Otten

| Hi,
|
[quoted text clipped - 16 lines]
|
| Dinesh

Reply to this Message

Ardus Petus - 18 May 2006 07:13 GMT

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

NB: your formula could be =SUM(A1:A3)

HTH
--
AP

> Hi,
>
[quoted text clipped - 17 lines]
>
> Dinesh

Reply to this Message

David Biddulph - 18 May 2006 08:19 GMT

> Hi,
>
[quoted text clipped - 8 lines]
>
> 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?

Signature

David Biddulph

Reply to this Message

Dinesh - 18 May 2006 16:40 GMT

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

> > Hi,
> >
[quoted text clipped - 18 lines]
> >
> > Is there a way to conver this?

Reply to this Message

N Harkawat - 19 May 2006 04:51 GMT

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

> Hi David,
>
[quoted text clipped - 33 lines]
>> >
>> > Is there a way to conver this?

Reply to this Message

Dinesh - 19 May 2006 05:32 GMT

Thanks. yes, very tedious if you have 10 combination.

> One possible method even though a little tedious is
> type the formula as if you would normally have done. Then press function
[quoted text clipped - 40 lines]
> >> >
> >> > Is there a way to conver this?

Reply to this Message