One or both of the cells contains text string?

You don't know how?

Show us what you have attempted to date.

I just use =cell1-cell2

If either or both the cells contain a negative you have to add, not subtract.


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 16:10:01 -0700, Awes1
wrote:

Why cant i subtract one cell from another?