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
1
Answer

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

1 Answer

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!