formatting the difference between two cells

  • Thread starter Thread starter Hollywood003
  • Start date Start date
H

Hollywood003

I have two cells with two different numbers and I am trying to have Excel
format the difference between the cells.
 
What do you mean by format the difference? Please elaborate.
 
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)
 
You must log in or register to reply here.

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
calculate week difference 2
Excel Macro to automatically go to the right of the last colored cell 0
What is the formula for totalling the number of days between two d 3
Length of time from date/time custom format 2
Shortcut for current Time in hh:mm:ss 2
conditional formatting 6
[newbie] formatting 3

Back
Top