formatting the difference between two cells

H

Hollywood003

I have two cells with two different numbers and I am trying to have Excel
format the difference between the cells.
 
D

David Biddulph

In Excel the symbol for minus is the minus sign (-), so the difference
between A1 and B1 is =B1-A1.
If you want only the magnitude of the difference, use =ABS(B1-A1)
 

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

Inconsistent formatting of section numbers 0
Deleting a Profile 1
Justification function versus wide spaces 0
I'm John, My first post. 0
Finding the right style field in VBA 0
Paste to excel from word - auto format problem 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Finding the proper style field and the numbered paragraph value within the style 0

Top