Penalty Provision in respect of delay in payment of P.F. dues

Penalty Provision in respect of delay in payment of P.F. dues
1.        Delay in deposit of P.F. dues attracts penal damages. Damages are levied at the following
           FLAT RATES:

• For 0 — 2 months delay – @ 5 % p.a.
• For 2 — 4 months delay – @10 % p.a.
• For 4 — 6 months delay – @ 15 % p.a.
• For delay above 6 months – @ 25 % p.a. (subject to a maximum of 100%)

2.        Levy of damages at lesser rates is not permissible under the EPF & MP Act.
3.        Reduction/Waiver of damages – considered only for Sick Industrial Companies having   
           rehabilitation scheme sanctioned by BIFR.

4.        Deposit dues in time – avoid penal damages.

All About Number Series

All About Number Series

What is Number Series?

Number series is a arrangement of numbers in a certain order, where some numbers are wrongly put into the series of numbers and some number is missing in that series, we need to observe and find the accurate number to the series of numbers.

In competitive exams number series are given and where you need to find missing numbers. The number series are come in different types. At first you have to decided what type of series are given in papers then according with this you have to use shortcut tricks as fast as you can .

Different types of Number Series

There are some format of series which are given in Exams.

Perfect Square Series:

This Types of Series are based on square of a number which is in same order and one square number is missing in that given series.

Example 1: 441, 484, 529, 576?

Answer: 441 = 21², 484 = 22², 529 = 23², 576 = 24² , 625 = 25².

Perfect Cube Series: 

This Types of Series are based on cube of a number which is in same order and one cube number is missing in that given series

Example 2: 1331, 1728, 2197, ?

Answer : 11³ ,  12³ ,  13³ ,  14³ 

Geometric Series:

This type of series are based on ascending or descending order of numbers and each successive number is obtain by multiplying or dividing the previous number with a fixed number.

Example 3: 5, 45, 405, 3645,?

Answer: 5 x 9 = 45, 45 x 9 = 405, 405 x 9 = 3645, 3645 x 9 = 32805.

Two stage Type Series:

A two tier Arithmetic series is one in which the differences of successive numbers themselves form an arithmetic series.

Example 4: i. 3, 9, 18, 35, 58,——

ii. 6, 9, 17, 23,———-

Mixed Series:

This type of series are more than one different order are given in a series which arranged in alternatively in a single series or created according to any non-conventional rule. This mixed series Examples are describes in separately.

Examples 5: 

11, 24, 50, 102, 206, ?

Answer: 

11 x 2 = 22 +2 = 24,

24 x 2 = 48 + 2 = 50,

50 x 2 = 100 + 2 = 102,

102 x 2 = 204 + 2 = 206,

206 x 2 = 412 + 2 = 414.

So the missing number is 414.

Number Series Quiz

Directions (1-10): What will come in place of the question marks (?) in the following Number series?

1.    0, 6, 24, 60, 120, 210, ?

A.  336       

B.  349

C.  312

D.  337

E.  None of these

2.    11, 14, 19, 22, 27, 30, ?

A.  39

B.  34

C.  36

D.  35

E.  None of these

3.    6, 12, 21, ? , 48

A.  33

B.  39

C.  36

D.  31

E.  None of these

4.    18, 22, 30, ? ,78, 142

A.  44

B.  35

C.  46

D.  48

E.  None of these

5.    73205, 6655, 605, 55, ?

A.  9

B.  5

C.  13

D.  11

E.  None of these

6.    25, 100, ?, 1600, 6400

A.  400

B.  300

C.  360

D.  420

E.  None of these

7.    125, ?, 343, 512, 729, 1000

A.  216

B.  215

C.  256

D.  225

E.  None of these

8.    1 , 9 , 125 , 343 , ? , 1331

A.  730

B.  729

C.  512

D.  772

E.  None of these

9.    121, 144, 169, ?, 225

A.  180

B.  172

C.  186

D.  196

E.  None of these

10.  ?, 2116, 2209, 2304, 2401, 2500

A.  2124

B.  1972

C.  1521

D.  2025

E.  None of these

Answers with Explanation:-

1.     (A)
The given series is : 1³ – 1, 2³ – 2, 3³ – 3, 4³ – 4, 5³ – 5, 6³ – 6,
So the missing term = 7³ – 7 = 343 – 7 = 336 .

2.    (D)
The pattern is + 3, + 5, + 3, + 5, …………
So the missing term is = 30 + 5 = 35 .

3.    (A)
The pattern is + 6, + 9, + 12, +15 ………..
So the missing term is = 21 + 12 = 33 .

4.    (C)
The pattern is +4, +8, +16, +32, +64
So the missing term is = 30 + 16 = 46 .

5.    (B)

5 x 11 = 55, 55 x 11 = 605, 605 x 11 = 6655, 6655 x 11 = 73205

6.    (A)

25 x 4 = 100, 100 x 4 = 400, 400 x 4 = 1600, 1600 x 4 = 6400.

7.    (A)

 125 = 5³ , 216 = 6³, 343 = 7³, 512 = 8³, 729 = 9³, 1000 = 10³.

8.    (B)

 1³ , 3³ , 5³ , 7³ , 9³ , 11³

9.    (D)

121 = 11², 144 = 12², 169 = 13², 196 = 14², 225 = 15².

10.  (D)

 2025 = 45², 2116 = 46², 2304 = 48², 2401 = 49², 2500 = 50²

TIME TAKEN

Within 5 min         : EXCELLENT

5-8 min                 : YOU CAN DO BETTER

More than 8 min   : YOU NEED TO WORK HARD

Current Affairs Questions for IBPS RRB PO and Clerk 2017

Q1. Which of the following Bank has recently unveiled two new digital services for online payments, viz Bharat QR (Quick Response) and Bharat Bill Payment System (BBPS)?
(a) Indian Bank
(b) Indian Overseas Bank
(c) SBI
(d) Canara Bank
(e) Bank of Baroda

S1. Ans.(d)
Sol. Canara Bank unveiled two new digital services for online payments. Bharat QR (Quick Response) is for payment settlement at merchant locations and Bharat Bill Payment System (BBPS) is an integrated bill payment system for net banking customers.

Q2. Name the Poet and writer (died recently), who became the first All India Poetry Champion in 1988.
(a) Manohar Vijay
(b) Chaitanya sen
(c) Vijay Nambisan
(d) Kamal Narayan Thakur
(e) Rubal Malik

S2. Ans.(c)
Sol. Poet and writer Vijay Nambisan, who became the first All India Poetry Champion in 1988, passed away. He co-authored Gemini, a poetry book, with Jeet Thayil and Dom Moraes.

Q3. The 15th Ministerial Meeting of BIMSTEC concluded recently in Nepal. What does 'M' stands for in BIMSTEC?
(a) Multi-Sectoral
(b) Marketing
(c) Mankind
(d) Multi-Lingual
(e) Ministerial

S3. Ans.(a)
Sol. The 15th Ministerial Meeting of Bay of Bengal Initiative for Multi-Sectoral Technical and Economic Cooperation (BIMSTEC) concluded at Kathmandu, Nepal.

Q4. The Centre has appointed lyricist Prasoon Joshi as Chairman of the Central Board of Film Certification (CBFC). He has replaced _____________.
(a) Leela Samson
(b) Pahlaj Nihalani
(c) Arvind Trivedi
(d) Asha Parekh
(e) Shakti Samanta

S4. Ans.(b)
Sol. The Centre has appointed lyricist Prasoon Joshi as Chairman of the Central Board of Film Certification (CBFC) for a period of three years. Mr. Joshi has replaced former Chairman Pahlaj Nihalani.

Q5. National Mission for Clean Ganga has recently approved how many projects in Bihar, West Bengal and Uttar Pradesh to the tune of about Rs 2,033 crore?
(a) 8
(b) 15
(c) 10
(d) 12
(e) 5

S5. Ans.(c)
Sol. National Mission for Clean Ganga has approved ten projects in Bihar, West Bengal and Uttar Pradesh to the tune of about Rs 2,033 crore. Eight of the ten projects pertain to sewage infrastructure and treatment, one to river front development and one to Ganga Knowledge Centre.

Q6. The Government of India has decided to launch a new sub-scheme named “AGEY” as part of the Deendayal Antyodaya Yojana – National Rural Livelihoods Mission (DAY-NRLM). What does AGEY stands for?
(a) Aajeevan Gaanv Express Yojana
(b) Aadhunik Grameen Express Yojana
(c) Aayojan Grameen Economical Yojana
(d) Aajeevika Grameen Express Yojana
(e) Aadhunik Grameen Extension Yojana

S6. Ans.(d)
Sol. The Government of India has decided to launch a new sub-scheme named “Aajeevika Grameen Express Yojana (AGEY)” as part of the Deendayal Antyodaya Yojana – National Rural Livelihoods Mission (DAY-NRLM).

Q7. Name the Indian athlete who has been appointed WHO Goodwill Ambassador for Physical Activity in South-East Asia Region.
(a) Milkha Singh
(b) P T Usha
(c) Anju Bobby George
(d) Sachin Tendulkar
(e) Mahesh Bhupathi

S7. Ans.(a)
Sol. Legendary Indian athlete Milkha Singh has been appointed WHO Goodwill Ambassador for Physical Activity in South-East Asia Region.

Q8. Ruth Pfau, known locally as Pakistan's Mother Teresa, passed away recently. She was basically from which country?
(a) Russia
(b) Italy
(c) Germany
(d) Spain
(e) USA

S8. Ans.(c)
Sol. Ruth Pfau, a German nun who devoted her life to combatting leprosy in Pakistan, has died at the age of 87. Pfau, who was known locally as Pakistan's Mother Teresa, came to the southern port city of Karachi in 1960 and spent half a century taking care of some of the country's sickest and poorest people.

Q9. The International Youth Day was observed across the world on _____________.
(a) 10 August
(b) 8 August
(c) 15 August
(d) 12 August
(e) 13 August

S9. Ans.(d)
Sol. The International Youth Day was observed across the world on 12 August with the theme 'Youth Building Peace'.

Q10. Yisrael Kristal, world's oldest man passed away recently at the age of 113. He was from which country?
(a) Indonesia
(b) Israel
(c) Oman
(d) Somalia
(e) Iran

S10. Ans.(b)
Sol. Israeli Holocaust survivor Yisrael Kristal, certified by Guinness World Records as the world’s oldest man, died aged 113.

Q11. Which of the following lender has recently introduced two tier interest rate structures for saving bank accounts?
(a) Indian Bank
(b) Bank of Baroda
(c) IDBI Bank
(d) HDFC Bank
(e) UCO Bank

S11. Ans.(a)
Sol. According to the PSU lender Indian Bank, it has introduced two tier interest rate structure for saving bank accounts and will offer interest rate of 4 per cent per annum on savings account with incremental balance of over Rs 50 lakh and 3.50 per cent per annum for deposit up to Rs 50 lakh.

Q12. Which of the following state government in association with the World Resources Institute (WRI) India has launched the ‘Smart Streets Lab’ program?
(a) Uttar Pradesh
(b) Uttarakhand
(c) Maharashtra
(d) Andhra Pradesh
(e) Telangana

S12. Ans.(e)
Sol. The government of Telangana in association with the World Resources Institute (WRI) India – Ross Centre and the Indian School of Business (ISB) launched the ‘Smart Streets Lab’ program.

Q13. National Payments Corporation of India (NPCI) has recently appointed ____________ as acting Chief Executive Officer (CEO).
(a) Sandeep Kumar
(b) Dilip Asbe
(c) Anita Joshi
(d) Manoj Saxena
(e) Rohan Bhagwat

S13. Ans.(b)
Sol. National Payments Corporation of India (NPCI) has appointed Dilip Asbe to act as its chief executive officer in the wake of the retirement of A. P. Hota, its founding managing director.

Q14. What is the theme of International Youth Day 2017?
(a) Youth Building Nation
(b) Empowering Youth
(c) Youth Building Peace
(d) World with Youth
(e) Building Partnership with Youth

S14. Ans.(c)
Sol. The International Youth Day was observed across the world on 12 August with the theme 'Youth Building Peace'.

Q15. Who is the present Director-General of World Health Organization?
(a) Margaret Chan
(b) Takehiko Nakao
(c) Claude Juncker
(d) Manuel Barroso
(e) Tedros Adhanom Ghebreyesus

S15. Ans.(e)
Sol. Dr. Tedros Adhanom Ghebreyesus is the Director-General of WHO for the term of 5 Years.WHO headquarters in Geneva, Switzerland.

Latest Rules On Provident Fund Withdrawal You Should Know: 10 Facts

The Employees' Provident Fund Organisation (EPFO) has been taking many steps to ease the process of provident fund (PF) money withdrawal. The PF money can be withdrawn after two months from the cessation of employment. The application form can be filed with the PF authorities or through the employer. PF is meant for saving towards retirement years. Financial planners advise not to withdraw from the corpus before retirement. According to provident fund norms, 12 per cent of an employee's salary goes into the fund along with a matching contribution from the employer. The Employees' Provident Fund Organisation every year announces interest rate to be paid on the accumulated provident fund corpus.

Here are 10 things to know:

1) To encourage long-term savings, the government has formulated tax laws accordingly. If the withdrawal from a recognised PF happens after five years of continuous employment, it attracts no tax liability. In case of employment with different employers, if the PF balance maintained with the old employer is transferred to the PF account of the new employer, it is considered a continuous employment.

2) If an employee has been terminated because of certain reasons beyond his or her control (such as ill health and discontinuation of business of employer), the withdrawal does not attract any tax, irrespective of the number of years of employment.

3) In case of a withdrawal before five years, the amount becomes taxable in the same financial year. Thus, the amount has to be shown in your tax return for the next assessment year. The employer's contribution to PF and interest earned on it is added to one's income and taxed accordingly.

4) In addition, if you have claimed benefits under Section 80C on your own PF contribution, it will be taxed as salary. The interest earned on your own contribution will be taxed as 'income from other sources' and taxed according to the respective tax slabs.

5) TDS (tax deducted at source) - If the withdrawal is after a period of five years of continuous employment, it attracts no TDS or any tax. What happens if the period of service is less than five years? If PAN has not been submitted to the EPFO authorities, TDS is deducted at 30 per cent. If PAN has been submitted along with Form 15G/15H, no TDS is deducted. If form 15G/15H is not submitted and PAN is submitted, TDS @ 10% is deducted. Form 15H or 15G is meant to prevent TDS for those whose income falls below the taxable limit.

6) The funds transferred from a recognised provident fund (PF) account to a National Pension System (NPS) account will not attract any tax, Pension Fund Regulatory and Development Authority (PFRDA) said in a circular dated March 6. "The amount so transferred from recognised Provident Fund/Superannuation Fund to NPS is not treated as income of the current year and hence not taxable," the pension fund regulator said.

7) The Employees' Provident Fund Organisation has come out with a single-page form for provident fund related claims - from provident/pension fund withdrawal to the advance facility.

8) In addition, an Employees' Provident Fund Organisation or EPFO subscribers can submit the new one-page form directly to the retirement fund body without the employer's attestation if their accounts are seeded with Aadhaar and bank account details.

9) For subscribers who are yet to seed Aadhaar and bank details, a new composite claim form has been introduced which has to be submitted with attestation of employers for any claims.

10) Also, no other document would be required to be submitted by the subscriber for taking advances from the provident fund corpus. A provident fund subscriber can go for partial withdrawal/advance from his or her corpus for specific purposes like purchase of flat, construction, marriage/education of children etc.

Computer Support: Java

Java

Blackboard Vista uses the Java Runtime Environment for certain key features, including file uploads and chat. You must have Java installed on your computer in order to use Blackboard. To install Java, do the following:

Windows XP/Vista/ Windows 7: Java Installation

Go to Java Website and Download the Free Software

Mac: Java Installation

If you are using Mac OSX - Snowleopard to access Blackboard, Java should have come preinstalled on your computer. Please use the Software Update feature to make sure you have the most recent version.

Still having problems go to Java for Macs website.

Java Troubleshooting

Several of the common issues users experience have to do with their installation of Java. If, when using Blackboard, you experience difficulty with any of the following, chances are it may be a problem with Java:

• Uploading files (the My Computer icon is missing)
• Using Wimba
• Using Chat
• Editing web pages using the Blackboard HTML editor
• Seeing the Blackboard gradebook (visible only to instructors and TAs).

If you are experiencing difficulty with any of these, see the following site on troubleshooting Blackboard Java Issues.

Java Troubleshooting

Troubleshooting Blackboard Java Issues

Java is a software platform that, like Flash, runs within a web browser to display certain content and run certain web applications. Blackboard uses Java for some of its functionality, most importantly:

• Uploading files and attachments (i.e. the My Computer icon will not appear if Java is missing or not functioning properly)
• Loading the Blackboard gradebook
• Editing pages using the built-in HTML Creator
• Loading SCORM objects (including certain activities, worksheets, and other interactive or sharable content)
• Checking for browser incompatibilities at login

When you or someone you support is having problems with one or more of these functions in Blackboard, odds are the problem originates in the Java setup on the computer accessing Blackboard.

Most Common Steps for Troubleshooting Java Issues

Most Java-setup issues can be resolved in one or more of the following ways:

• Install or update Java.
• Clear the Java cache (often along with the browser cache).
• Troubleshoot Java certificate settings
• Remove multiple installed versions of Java (Rarely problematic)

Install or Update Java

To install the latest version of Java, visit http://www.java.com and follow the download link and instructions provided there.

Clear the Java Cache

Occasionally a problem arises in which the Blackboard gradebook fails to load, but instead a blank white screen appears. The solution to this problem is to clear the browser cache and then the Java cache. To clear the Java cache, complete the steps on the following link:

Clearing the Java Cache

Troubleshoot Java Security Settings

If Java is installed but you are still having problems with Java functionality in Blackboard, there might be a problem with the Java security certificate settings on your computer. Here are two things to look for:

1. The application digital signature has not been allowed to run.
2. The certificate information stored on the comptuer does not match the current certificate.

Please see the following link for more details.

Troubleshooting Java certificate problems in Blackboard

Remove multiple installed versions of Java

When Java is updated, older versions are not removed but are left installed on the computer. On rare occasion this can lead to problems.To remove old versions, go to the Control panel of your PC (located within the "Start" menu, and select the option to Add or Remove programs. Scroll through the list of installed programs and remove all but the latest version of Java.

Note that before taking this step, it would be good to know whether other software running on your computer requires an older version of Java than the latest. If so, you may want to keep that Java version installed on your computer.

For Mac users, multiple versions of Java is not a problem.

Clearing the Java Cache

Occasionally a problem arises involving the Java cache. Most typically this is seen in cases where the Blackboard gradebook fails to load, but instead a blank white screen appears. The solution to this problem is to clear the browser cache and then the Java cache. To clear the Java cache, complete following steps:

Windows

1. Open a web browser and login to Blackboard. This will initiate Java on your computer.
2. Look for the Java icon located in the bottom-right corner of the Windows task bar.
   
3. Right click on the icon and select "Open Control Panel."
   
4. Once the control panel is open, click the "Settings" button under the General tab.
   
5. Next, click the "Delete Files" button.
   
6. When prompted to "Delete the following temporary files," make sure both options are checked and click "OK."
   

Mac OSX

1. Using the spotlight tool, search for "Java Preferences"
   
2. Open Java Preferences and click the "Network" tab.
   
3. Click the "Delete Files" button.
   
4. When prompted to "Delete the following temporary files," make sure both options are checked and click "OK."
   

Troubleshooting Java Certificate Settings

If Java is installed on your computer, but you are still having problems with Java functionality in Blackboard (see Troubleshooting Java Issues in Blackboard), there might be a problem with the Java security certificate settings on your computer. Here are two things to look for, with tips to troubleshoot:

1. The application digital signature has not been allowed to run

When you login to Blackboard for the first time on a given computer, you are greeted with a prompt that reads "The application's digital signature has been verified. Do you want to run the application?" You must select "Run" for Java-driven functionality to work within Blackboard.

If you accidentally select "Cancel," you should be able to restart your browser and then login again. This will bring up the prompt, allowing you to select "Run."

When you select "Run," you tell your Java installation to trust the Java security certificate that Blackboard uses. That information is stored away so that you do not have to keep selecting "Run" every time you login

2. The certificate information stored on the comptuer does not match the current certificate

Every once in a while, the Java security certificate on Blackboard is renewed, which may cause problems if the certificate information stored on your comptuter does not match. To see if this is the case, you must clear out your stored Blackboard certificates in Java. Below are the steps for doing so.

Windows

1. Open a web browser and login to Blackboard. This will initiate Java on your computer.
2. Look for the Java icon located in the bottom-right corner of the Windows task bar.
   
3. Right click on the icon and select "Open Control Panel."
   
4. Once the control panel is open, select the "Security" tab.
   
5. Click the "Certificates" button.
6. Highlight any certificates containing the word "blackboard" and click the "Remove" button.
   

Mac OSX

1. Using the spotlight tool, search for "Java Preferences"
   
2. Open Java Preferences and select the "Security" tab.
   
3. You will see a list of sites that Java will run signed content from without prompting. Highlight any certificates containing the word "Blackboard" and click the "Delete" button (which appears as a minus sign).

How to convert a numeric value into English words in Excel

Summary

This article contains sample Microsoft Visual Basic for Applications functions that you can use to convert a numeric value in a Microsoft Excel worksheet cell into its equivalent in English words.

More Information

This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures.

How to create the sample function Called Spellwords

1.      Start Microsoft Excel.

2.      Press ALT+F11 to start the Visual Basic Editor.

3.      On the Insert menu, click Module.

4.      Type the following code into the module sheet.

Function Spellwords(amt As Variant) As Variant

Dim FIGURE As Variant

Dim LENFIG As Integer

Dim i As Integer

Dim WORDs(19) As String

Dim tens(9) As String

WORDs(1) = "One"

WORDs(2) = "Two"

WORDs(3) = "Three"

WORDs(4) = "Four"

WORDs(5) = "Five"

WORDs(6) = "Six"

WORDs(7) = "Seven"

WORDs(8) = "Eight"

WORDs(9) = "Nine"

WORDs(10) = "Ten"

WORDs(11) = "Eleven"

WORDs(12) = "Twelve"

WORDs(13) = "Thirteen"

WORDs(14) = "Fourteen"

WORDs(15) = "Fifteen"

WORDs(16) = "Sixteen"

WORDs(17) = "Seventeen"

WORDs(18) = "Eighteen"

WORDs(19) = "Nineteen"

tens(2) = "Twenty"

tens(3) = "Thirty"

tens(4) = "Fourty"

tens(5) = "Fifty"

tens(6) = "Sixty"

tens(7) = "Seventy"

tens(8) = "Eighty"

tens(9) = "Ninety"

FIGURE = amt

FIGURE = Format(FIGURE, "FIXED")

FIGLEN = Len(FIGURE)

If FIGLEN < 12 Then

FIGURE = Space(12 - FIGLEN) & FIGURE

End If

If Val(Left(FIGURE, 9)) > 1 Then

Spellwords = "Rupees ("

ElseIf Val(Left(FIGURE, 9)) = 1 Then

Spellwords = "Rupee "

End If

For i = 1 To 3

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

Spellwords = Spellwords & tens(Val(Left(FIGURE, 1)))

Spellwords = Spellwords & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

If i = 1 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & " Crore "

ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & " Lakh "

ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & " Thousand "

End If

FIGURE = Mid(FIGURE, 3)

Next i

If Val(Left(FIGURE, 1)) > 0 Then

Spellwords = Spellwords & WORDs(Val(Left(FIGURE, 1))) + " Hundred "

End If

FIGURE = Mid(FIGURE, 2)

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

Spellwords = Spellwords & tens(Val(Left(FIGURE, 1)))

Spellwords = Spellwords & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

FIGURE = Mid(FIGURE, 4)

If Val(FIGURE) > 0 Then

Spellwords = Spellwords & " and Paise "

If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then

Spellwords = Spellwords & WORDs(Val(Left(FIGURE, 2)))

ElseIf Val(Left(FIGURE, 2)) > 19 Then

Spellwords = Spellwords & tens(Val(Left(FIGURE, 1)))

Spellwords = Spellwords & WORDs(Val(Right(Left(FIGURE, 2), 1)))

End If

End If

FIGURE = amt

FIGURE = Format(FIGURE, "FIXED")

If Val(FIGURE) > 0 Then

Spellwords = Spellwords & ") Only "

End If

End Function

How to use the Spellwords sample function

To use the sample functions to change a number to written text, use one of the methods demonstrated in the following examples:

Method 1: Direct Entry

You can change 67.35 into " Rupees (SixtySeven and Paise ThirtyFive) Only" by entering the following formula into a cell:

=Spellwords(67.35)

Method 2: Cell reference

You can refer to other cells in the workbook. For example, enter the number 67.35 into cell A1, and type the following formula into another cell:

=Spellwords(A1)

Method 3: Insert Function

To use Insert Function, follow these steps:


Excel 2003:

1.   Select the cell that you want.

2.   Click Insert Function on the Standard toolbar.

3.   Under Or select a category, click User Defined.

4.   In the Select a function list, click Spellwords, and then click OK.

5.   Enter the number or cell reference that you want, and then click OK.

Excel 2007 and 2010:

1.   Select the cell that you want.

2.   Click Insert Function on the Formulas ribbon.

3.   Under Or select a category, click User Defined.

4.   In the Select a function list, click Spellwords, and then click OK.

Enter the number or cell reference that you want, and then click OK.

How to change the sample function Called Spellwords to other name

1.      Start Microsoft Excel.

2.      Press ALT+F11 to start the Visual Basic Editor.

3.      On the Insert menu, click Module.

       4.      In the module sheet press Ctrl+H then in Find What                place insert Spellwords and in Replace with insert                  your desire name then click on Replace all.