This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How can I calculate and format the difference between 2 numbers in Excel? I want to show the difference as either an 'increase' (positive) or a 'decrease' (as a negative, displayed with a minus sign prior to the number, e.g. -5; to show a downward movement in the score). In cell a3 is the 'before' number, e.g. 20. In cell b3, is the 'after' number, e.g. 15. I want to calculate the difference between these 2 numbers. I was proposing to use an 'IF' statement to calculate the difference.
I also want to show the difference (movement of current risk score) as follows:
If the 'risk score before' is greater than the 'risk score after', then show the 'difference' as a 'negative' (preceded with a minus).
If the 'risk score before' is less than the 'risk score after', then show the difference as a 'positive'.
If the 'risk score before' is equal to the 'risk score after', then display 'no movement' (or leave blank) as the 'difference'
Thanking you in anticipation.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi Sarah
The videos and the link below would help you with your last request, and probably give you more ideas for future projects.
Regards
Jeovany
https://exceljet.net/custom-number-formats
VIDEOS
https://www.youtube.com/watch?v=tGY70sdpaLc
In C3 put in this formula.
=B3-A3
With C2 still selected, tap Ctrl+1 and go to the Numbers tab. Choose Custom from the list down the left and supply the following for the Type;
0;-0;"No movement";
Now double click the small Fill Handle in the lower right corner of C3. This should populate the formula down as far as there are values in column B.
Thank you so much for pointing me in the direction of these videos - they are so helpful.
Thank you so much for your help in solving my query.
Would it be possible to explain the solution please?
I haven't used the 'Custom' format cells option in this way before. Is this similar to using an 'If' Function?
Can it be used in other ways?
Many thanks.