if statement - How to display large numbers in their abbreviated

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

2. Working with Sum IF and Count IF statements.

Routing table - Wikipedia

OD vs. OS: A Complete Guide to Eye Abbreviations

Element Notation & Subscript Numbers, Overview & Differences - Lesson

Diffie–Hellman key exchange - Wikipedia

APA Running Head Example + Instructions for Word & Docs

Understanding Part-of-Speech Tagging in NLP: Techniques and Applications - Shiksha Online

35 Texting Abbreviations, Text Abbreviations and How to Use Them

Telephone exchange names - Wikipedia

What Is Pi, and How Did It Originate?

Formatting Numbers for Printing in Python

Part number - Wikipedia