Please, How to square monetary unit ($ for exemple) while calculating variance in Excel?
Thanks for reaching out.
It shouldn’t make any difference. You use the exact same formula.
The currency formatting is perceived by Excel as numbers, so you shouldn’t have problems with it. If you do, please feel free to post a screenshot here.
You get that as a custom format for the cell where your variance value would go. You would need to format the cell so that positive values start/end with the corresponding currency symbol ($ for instance) and add a 2nd power superscript after. To get to the custom format panel, right mouse click the cell and click on “format cells”. Then head to the “custom” tab and specify the format mentioned earlier.
Hope this helps!