Powered by

# 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 Formula
  2. Select the range -- A1:Z999
  3. "Custom Formula is" =$F$1:$F999="phrase"

# References