The SEQUENCE function, can accept starting values and step sizes to further customize the sequence, making it ideal for dynamic numbering systems like automatic serial numbers or ordered data entries.
Check the value of your NPS holdings (investments), either month-wise or year-wise, including notional gains/losses as of today or projected at retirement.
This function allows you to easily find data related to your keywords using a combination of three functions with the QUERY function in Google Sheets, FILTER, ISNUMBER and SEARCH.
2c11ou0n2tL0e0n6, if you want to keep only the letters and remove the non-letter characters, use the formula: =REGEXREPLACE (B3, "[^a-zA-Z]", "")
In the UPS, averaging over 12 months reduces the benefit of any recent promotion, whereas in the OPS, the pension directly reflects the highest recent pay
How to calculate the income tax if you are a government employee and get an annual salary or income from other source between ₹ 5.0 Lakhs to ₹ 20.08 Lakhs.
The basic pension under UPS is ₹34,475, compared to ₹36,400 under OPS, and the total difference, including Dearness Allowance, is ₹3,888.
On Saturday, August 24, 2024, the NDA-led central government introduces the “Unified Pension Scheme” (UPS), a new initiative designed to reform pension benefits. The scheme aims to mirror the objectives of the old pension scheme, which was discontinued by the NDA…
IMPORTRANGE function in Google Sheets allows you to import data from one spreadsheet to a destination sheet.
Google Sheets offer a wide range of formulas (approx.513) to perform various calculations, data manipulations, and analysis tasks.