Show me the difference

If I have 2 cells containing us currency values and want to compare them and report the difference in another cell showing the value as a positive or negative value, what might be the proper formula. example: a calculated value in D2 of $6.10 and E2=$6.00 would show -$0.10 in F2
Conversely if D2=$6.00 and E2=$6.10 then F2 would show +$0.10.
Any help appreciated.

Hi there,

See if the following six steps does the job for you:

1. Enter =E2-D2 in cell F2 and copy down as required
2. Highlight Column F and from the Format menu, select Cells
3. From the Format Number dialog box, ensure the Number tab is selected
4. Select the Custom option from the Category listbox
5. Enter $+#,##0.00;-$#,##0.00 in the Type textbox
6. Click OK

HTH

Robert

Hello sgrutherford,

Format the cells as Currency and then add a formula in the third cell to subtract the first and second cell

Please Login or Register  to view this content.

Sincerely,
Leith Ross