🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

How to square monetary unit ($ for exemple) while calculating variance in Excel

How to square monetary unit ($ for exemple) while calculating variance in Excel

Super Learner
0
Votes
2
Answer

Hi,
Please, How to square monetary unit ($ for exemple) while calculating variance in Excel?
 
Thank you.

2 Answers

365 Team
0
Votes

Hi!
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.
Thanks!

Super Learner
0
Votes

Hi,
 
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!