Cause formulae totals to reflect negative and positive amount inpu
 

I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8 is
(2100.00), that negative amount is converted to a positive amount by both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.

Cause formulae totals to reflect negative and positive amount inpu
 

P8 doesn't appear in the second formula which could have been written as:
=aa6+y8-z8
(no need for =sum())

I don't understand what you mean your question.

You may want to include some info about what's in those cells and what you
expected from each formula.



lawrencae wrote:

I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8 is
(2100.00), that negative amount is converted to a positive amount by both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.


--

Dave Peterson

Cause formulae totals to reflect negative and positive amount inpu
 

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8 is
(2100.00), that negative amount is converted to a positive amount by both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.

Cause formulae totals to reflect negative and positive amount inpu
 

Or maybe...

=K8+Y6-SUM(abs(L8:X8))
(as an array formula)



RagDyer wrote:

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8 is
(2100.00), that negative amount is converted to a positive amount by both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.



--

Dave Peterson

Cause formulae totals to reflect negative and positive amount inpu
 

Since each formula is *not* calculating the same way, and returning
different results, I guess it's up to the OP on exactly what he's looking
for.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Or maybe...

=K8+Y6-SUM(abs(L8:X8))
(as an array formula)



RagDyer wrote:

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect
both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8
is
(2100.00), that negative amount is converted to a positive amount by
both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.



--

Dave Peterson

Cause formulae totals to reflect negative and positive amount inpu
 

I didn't mean to suggest that it would calculate the same. I really was trying
to proffer an alternative interpretation.



RagDyer wrote:

Since each formula is *not* calculating the same way, and returning
different results, I guess it's up to the OP on exactly what he's looking
for.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Or maybe...

=K8+Y6-SUM(abs(L8:X8))
(as an array formula)



RagDyer wrote:

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in an
accounting spread sheet. How can these formulae be made to reflect
both
negative and positive amounts in the data cells they drawing data from.

As it stands now, if a given cell has a negative amount in it, e.g., P8
is
(2100.00), that negative amount is converted to a positive amount by
both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.



--

Dave Peterson

--

Dave Peterson

Cause formulae totals to reflect negative and positive amount inpu
 

And I didn't mean to suggest that you didn't know that.<g

Was for OP's benefit.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
I didn't mean to suggest that it would calculate the same. I really was
trying
to proffer an alternative interpretation.



RagDyer wrote:

Since each formula is *not* calculating the same way, and returning
different results, I guess it's up to the OP on exactly what he's looking
for.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Or maybe...

=K8+Y6-SUM(abs(L8:X8))
(as an array formula)



RagDyer wrote:

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in
an
accounting spread sheet. How can these formulae be made to reflect
both
negative and positive amounts in the data cells they drawing data
from.

As it stands now, if a given cell has a negative amount in it, e.g.,
P8
is
(2100.00), that negative amount is converted to a positive amount by
both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.



--

Dave Peterson

--

Dave Peterson

Cause formulae totals to reflect negative and positive amount inpu
 

<vbg

RagDyeR wrote:

And I didn't mean to suggest that you didn't know that.<g

Was for OP's benefit.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
I didn't mean to suggest that it would calculate the same. I really was
trying
to proffer an alternative interpretation.

RagDyer wrote:

Since each formula is *not* calculating the same way, and returning
different results, I guess it's up to the OP on exactly what he's looking
for.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Or maybe...

=K8+Y6-SUM(abs(L8:X8))
(as an array formula)



RagDyer wrote:

Try these:

=K8+Y6-ABS(SUM(L8:X8))

=AA6+Y8-ABS(Z8)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------

"lawrencae" wrote in message
...
I have these two formulae, =K8+Y6-SUM(L8:X8) and =SUM(AA6+Y8-Z8), in
an
accounting spread sheet. How can these formulae be made to reflect
both
negative and positive amounts in the data cells they drawing data
from.

As it stands now, if a given cell has a negative amount in it, e.g.,
P8
is
(2100.00), that negative amount is converted to a positive amount by
both
formulae, thus a positive 2100.00 is added to the total rather than
subtracting the negative (2100.00) showing in cell P8.



--

Dave Peterson

--

Dave Peterson

--

Dave Peterson