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

Difference between two times in seconds 1
What is the formula for totalling the number of days between two d 3
format cells depending on value range 5
Find difference between 2 cells if critera in a 3rd cell is met 3
calculate week difference 2
Compare multiple cells and highlight differences 5
Excel Macro to automatically go to the right of the last colored cell 0
[newbie] formatting 3

Top