Referencing a negative value
 

When I reference a cell with a negative value, the cell from which I'm
referencing converts the value to a positive number.

Does anyone know why this is happening??

Thanks

Referencing a negative value
 

hi
how are you referencing the cell?

Regards
FSt1

"Chuck W" wrote:

When I reference a cell with a negative value, the cell from which I'm
referencing converts the value to a positive number.

Does anyone know why this is happening??

Thanks

Referencing a negative value
 

hey,

=b21



"FSt1" wrote:

hi
how are you referencing the cell?

Regards
FSt1

"Chuck W" wrote:

When I reference a cell with a negative value, the cell from which I'm
referencing converts the value to a positive number.

Does anyone know why this is happening??

Thanks

Referencing a negative value
 

Are you sure that the original cell is negative--maybe it's just formatted to
look negative.

And you'd want to check the cell with the formula--it could be formatted to make
it look positive.



Chuck W wrote:

When I reference a cell with a negative value, the cell from which I'm
referencing converts the value to a positive number.

Does anyone know why this is happening??

Thanks

--

Dave Peterson