Change number format based on cell value | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
https://exceloffthegrid.com/change-nu...
★ About this video ★
You've built an amazing dynamic report where a user can select a business unit to view, and everything updates automatically - it's beautiful. The only issue is that Company A has sales of $30,000,000, Company B has sales of $30,000.
Displaying values in 1 decimal place millions makes sense for Company A. $30,000,000 becomes $30.0m. But it does not make sense for Company B. $30,000 become $0.0m - pretty useless.
The companies have different levels of significance. How can we format numbers so they work with either company?
We will look at two techniques in this post.
0:00 Introduction
0:33 TEXT Function
3:02 Conditional Formatting
5:50 Conclusion
What to know more about number formats?
Check this out: • Excel number formats for accounting &...
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel