SpreadSheet

A SpreadSheet is a computer application for organization, analysis and storage of data in tabular form. If you want to start a business, run it first in a SpreadSheet.

Tit-Bits

Format in Indian Currency (Lakhs, Crores)

₹ with decimals
[$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00

₹ without decimals
[$₹][>9999999]##\,##\,##\,##0;[$₹][>99999]##\,##\,##0;[$₹]##,##0

No ₹, with decimals
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

No ₹, without decimals
[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0

Year(s), Month(s), and Day(s) between dates

=IF(DATEDIF(A1, B1, "D")>365, QUOTIENT(DATEDIF(A1, B1, "D"), 365)&" year(s) "&
                          QUOTIENT(MOD(DATEDIF(A1, B1, "D"), 365), 30)&" month(s) "&
                      MOD(QUOTIENT(MOD(DATEDIF(A1, B1, "D"), 365), 30), 30)&" day(s)",
 IF(DATEDIF(A1, B1, "D")>30,  QUOTIENT(DATEDIF(A1, B1, "D"), 30)&" month(s) "&
                                   MOD(DATEDIF(A1, B1, "D"), 30)&" day(s)", 
                                       DATEDIF(A1, B1, "D")&" day(s)"))

Highlight rows that contains a phrase in a column

1. Choose “Conditional Formatting”
2. Select the Range. e.g. “A1:Z999”
3. Format Rules as “Custom Formula is” =$F$1:$F999="phrase"

References

• Google Sheets Functions