Subtracting Negative Numbers

C

Carole O

I've looked at other similar questions and responses (# VALUE), etc, and
tried the suggestions (N(C2)-N(D2), ABS, Text to columns, =C2-D2, and still
get the #VALUE. Some of the numbers in C2 are negative, but even two
positive numbers in C2 and D2 result in the # VALUE response.

The cells are formatted as numbers. Any ideas?

Carole O
 

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

Top