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.