H Hollywood003 Oct 26, 2009 #1 I have two cells with two different numbers and I am trying to have Excel format the difference between the cells.
I have two cells with two different numbers and I am trying to have Excel format the difference between the cells.
D David Biddulph Oct 26, 2009 #3 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)
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)
