Cause formulae totals to reflect negative and positive amount inpu

[lawrencae]

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]

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.

 

[RagDyer]

Try these:

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

=AA6+Y8-ABS(Z8)

 

[Dave Peterson]

Or maybe...

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

 

[RagDyer]

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.

 

[Dave Peterson]

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

 

[RagDyeR]

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

Was for OP's benefit.

 

[Dave Peterson]

<vbg>

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 !
-----------------------------------------------------------------------------------------------

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