How to get values using custom number format in single formula in Google Sheets

Asked Apr 15 '23 at 05:19

Active Apr 15 '23 at 07:41

Viewed 37 times

How to get values using custom number format in single formula in Google Sheets?

I want values >10000000 Crore to be 1Cr, >100000 Lakh to be 1L, <99999 Thousand to be 99T

I have tried something like this

[<100000]0.00,"K";#\.00"L"

[<10000000]#\.00,"L";#\.0000,"Cr"

But this is two different formulas and I want a single formula

edited Apr 15 '23 at 07:41

James Z

asked Apr 15 '23 at 05:19

Is this Q&A helpful? [Displaying Lakhs and Crores in Google Sheets](https://stackoverflow.com/q/32359814/1330560). There are also a couple of other questions about formatting of Indian Currency, have you researched these? – Tedinoz Apr 16 '23 at 02:04

0 Answers0