+A2 results in zero???

  • Thread starter Thread starter Fred Marshall
  • Start date Start date
F

Fred Marshall

I generated a spreadsheet with QuickBooks to look at a Budget. I mention
this only for context.

I'm changing the spreadsheet manually and have come onto something I don't
understand:

There is a column of numbers let us say in column A.
In A10 there is a number.
In A21 there is a number.
In A54 there is =A10+A21 which results in a number.

I want to put B90=+A54.... well I type +A54 in B90 and I guess that's the
result ... or is it simply =A54?? no matter.

When I do this, the result is zero in B90!
When I put the same formula in quite a few other cells I get the same
result.

I want this strangeness to go away. I'm looking for ideas that would help.

Thanks,

Fred
 
Hi Fred,
I will make an assumption here because you have not made it clear in your
defining of the problem. That assumption is that I am assuming that you
want B90 to be the same value as A54, if this is the case then the formula
should simply be =A54.
If however you are trying to add the value of A54 to the value of B90 then
that becomes quite another problem and would depend on what is in B90 in the
first place and where that comes from, i.e.. is it a fixed value or is it a
formula.
Regards
Rob
 
Hi Fred,
I just want to add onto what Rob writes,
If u are trying to use B90=+A54, it has to work the right
way and should not result in 0 unless A54 itself is 0;
The characters that u should be entering in B90 should be
=A54 or =+A54. It WILL NOT give zero.

Thanks,
harsha
 
Hi Fred,

It's strange the result is zero.
I just guess will it be the problem of format.

You can check if the format is in thousand (in custom it shows 0, ) and if
your result is less than 500, it will show 0.

Regards
Eling
 
Back
Top