if statement - How to display large numbers in their abbreviated
![if statement - How to display large numbers in their abbreviated](https://i.stack.imgur.com/lsNuG.png)
I want to make a number format in Google Sheets that turns large numbers into their abbreviated form. Example: "1 200" -> "1.2k", "1 500 000 000 000 000" (one point five quadrillions) -> "1.5Qa". I
Solved ashot The Questions : (2 Marks): 1. Write a
![](https://www.wallstreetmojo.com/wp-content/uploads/2021/06/Million-Format-in-Excel-1.jpg)
Excel Million Format - Format Numbers To Millions & Thousands
![](https://learn.microsoft.com/en-us/power-bi/create-reports/media/desktop-custom-format-strings/custom-format-strings-02.png)
Use custom format strings in Power BI Desktop - Power BI
![](https://i.stack.imgur.com/NwvC1.png)
if statement - How to display large numbers in their abbreviated form? - Stack Overflow
![](https://upload.wikimedia.org/wikipedia/commons/thumb/4/42/Bgp_rtable.png/1200px-Bgp_rtable.png)
Routing table - Wikipedia
![](https://www.benlcollins.com/wp-content/uploads/2020/08/customNumberFormatMenu.jpg)
A Complete Guide To The Google Sheets Custom Number Format
![](https://www.thoughtco.com/thmb/6_xRFqtw0KJkS_CIJjd30moYDEM=/1500x0/filters:no_upscale():max_bytes(150000):strip_icc()/GettyImages-130895397-57a530aa5f9b58974ab7a0cb.jpg)
Math Glossary: Mathematics Terms and Definitions
![](https://i.stack.imgur.com/lsNuG.png)
if statement - How to display large numbers in their abbreviated form? - Stack Overflow
![](https://images.shiksha.com/mediadata/ugcDocuments/images/wordpressImages/2022_12_POS-Tagging.jpg)
Understanding Part-of-Speech Tagging in NLP: Techniques and Applications - Shiksha Online
![](https://upload.wikimedia.org/wikipedia/commons/thumb/9/96/Euclid%27s_algorithm_Book_VII_Proposition_2_3.svg/260px-Euclid%27s_algorithm_Book_VII_Proposition_2_3.svg.png)
Euclidean algorithm - Wikipedia