PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-ARABIC

INTRODUCTION

ARABIC function comes under the  category in Excel.

The ARABIC function accepts ROMAN numeral as an argument and returns the arabic numeral as output.

I II III IV V VI ….  are known as ROMAN NUMERALS and commonly used numbers like 1 2 3 4 5 … are called as ARABIC NUMBERS.

So this function is used to convert one form to the other.

This function can be used as subset of any bigger operation where we need to convert the Roman number choice into arabic numeral.

 

PURPOSE OF ARABIC FUNCTION IN EXCEL

ARABIC FUNCTION converts ROMAN NUMERALS (PUT AS AN ARGUMENT) into ARABIC NUMERALS.

PREREQUISITES TO LEARN ARABIC

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: ARABIC FUNCTION

The Syntax for the function is

=ARABIC(“ROMAN NUMERAL”)

ROMAN NUMERAL   Roman numeral in “”(QUOTES)

 

 

EXAMPLE:ARABIC FUNCTION IN EXCEL

DATA SAMPLE

Let us try to change few roman numerals into arabic using the same formula

GYANKOSH_ARABIC FUNCTION
EXCEL:ARABIC FUNCTION ANIMATED EXAMPLE

STEPS TO USE ARABIC FUNCTION

The two ways have been shown to use ARABIC FUNCTION

CASE1: The roman numerals are present in the cell from C3 to C10.

The output is taken in the cell D3 to D10.

The function used is

=ARABIC(C3)….ARABIC(C10)

 

CASE2: Directly using the text. The function is used as

=ARABIC(“IX”)

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW