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

Back to all questions

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

Super Learner 6 days ago
Vote Up Vote Down
0
Votes
1
Answer

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

#
1 Answer

365 Team 4 days ago
Vote Up Vote Down
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!

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #.