Sheeloo,

Why are we trying to make the formula an array? When I select the cell all
I see is "=CZ1:CZ2-AS2".

Short of contacting the creator of the spreadsheet I was trying to figure
out why that is done. Something is obviously wrong because it shouldn't
equal zero to me, with the exception of the first forumla.

Essentially I'd get 0+320-320=0 and 320+267-267=320, but the ending result
says 0.

I guess the formula is wrong, because CZ1 is a part of the header field.
The column header says # Units. It's a wonder the end result didn't return
an invalid error. I don't know the ins and outs of Excel, but something is
going on with the formula.

BTW...I tried adding the brackets to the first line and pressing
CTRL-Enter-Shift and the field no longer calculates....it only showed what
was typed in the cell.


"Sheeloo" wrote:

If you move to the cell with the formula (without getting into the Edit mode)
you will probably see the formula as
{=CZ1:CZ2-AS2}
{} indicate that the formula is an ARRAY formula.

If not then go to the first cell with the formula, edit it and press
CTRL-ENTER-SHIFT

It is essentially adding the current row and previous row values in CZ and
substracting the current row value in AS.

If you treate CZ as Credit column, AS as Debit column with opening balance
in CZ1, the formula will give you the balance...

Pl. mark this as answered if this is what it is.

"Miss Mattax" wrote:

Sheeloo; there is an equal sign before all of them.

The formula in row 2 is written =CZ1:CZ2-AS2.
The formula in row 3 is written =CZ2:CZ3-AS3, etc.


"Sheeloo" wrote:

Formulas have a "=" or "=" before them...

Pl. let us know the complete formula in CZ1, CZ2. I am assuming that you see
the result as 0...

Let us know.

"Miss Mattax" wrote:

I'm working on a worksheet that already has formulas listed and I don't
understand one of the formulas. FYI...all the formulas I'm listing equals a
total number of units.

The formula in row 2 is written CZ1:CZ2-AS2.
The formula in row 3 is written CZ2:CZ3-AS3, etc.

CZ 1 is blank because it's a part of the header, CZ2 = 320, CZ3 = 267, AS2
= 320, and AS3 = 267

I get that the author wants to compare that the original total of units (AS2
or AS3) matches what is in CZ2 or CZ3. The end result should be zero if the
units match.

What I don't get is why is one row being compared to a previous row.

Have any of you ever seen a formula like this? And it doesn't follow the
mathematical rules for me either. I'm assuming it's taking the sum of CZ1 &
CZ2 then subtracting AS2 from the total, but I don't understand how the end
result is always zero.

Please help. It's quite possible there's an error with the formula, but I
wanted to know if you all have ever seen a formula like the one metioned
above.

Thanks,