Referencing a negative value

C

Chuck W

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

directing a total to various cells dependent of its value 1
Negative percentage in data verification dropdown list? 2
calculate formula if cell value is positive, show 0 if negative 3
Custom Number Format for text 8
If, Then statements with a formula 1
Help with a pop-up msg 5
Reverse color numeric formatting? 2
Adding Hours 1

Top