Go Back

Excel ROMAN Function

Microsoft Excel is widely acknowledged for its versatility. It is commonly used for sorting out lists of numeric, text strings, alphanumeric, email, postal addresses, ZIP Codes, and so on. However, it also comprises of a unique and simple option which enable its users to convert regular whole numbers into ROMAN numbers. The following tutorial and pictorial illustrates that how a user can follow simple steps for finding out Excel ROMAN function on an Excel Spreadsheet.

Finding Out Excel ROMAN Function Using Excel:

Figure 1. Example of converting numbers into roman numbers using Excel ROMAN function

Formula:

=ROMAN(cell_number)

Explanation:

Microsoft Excel features a number of variations among numeric values. These numeric values could be converted into a desirable format using excel features. If you are considering converting whole numbers into roman numbers then, you can simply use Excel ROMAN function for obtaining the roman numbers.

A user is simply required to insert the function into a cell and press ENTER for converting a whole number into a roman number. If it is required to convert a long list of whole numbers into roman figures then, it can simply insert a formula in one cell, and it can use the arrow motions for dragging the formula down a column or straight in a row.

How does the formula work?

If you look at the example given above, you can see that we used the following setup for converting the numbers in Column B:

Figure 2. Example of converting numbers into roman numbers using Excel ROMAN function

Once the user presses ENTER, the value of (110) would be converted into (CX)—which is its counterpart. As mentioned previously, a user can simply drag the formula across the column, and the Excel ROMAN function would automatically generate Roman numbers of the corresponding whole numbers—as illustrated in Figure1.

 

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

You have been asked to develop a spreadsheet that will allow a builder to analyze what types of apartment buildings to build. Specifically, the builder needs to compare the income that comes in from the rent of apartments to the cost of building and running the apartments. The apartment buildings being considered will each have all one-bedroom, or all two-bedroom or all three-bedroom apartments. For each type, the builder will enter the following values: a) number of rooms in the apartment b) square footage of the apartment c) number of units of that type that will be in each building. In the example below, the three possible apartment buildings will have either 25 one-bedroom apartments, 20 two-bedroom apartments or 12 three-bedroom apartments. For your spreadsheet, use the following data. Remember that your spreadsheet should work for any data that is entered. Type of Apartment Number of rooms Apartment square footage Number of Units One-bedroom 2 600 25 Two-bedroom 3 1000 20 Three-bedroom 5 1300 12 Income there are 2 sources of income: Apartment rent State rebate 1) Rent - The monthly rent for each apartment is computed by the following formula: rent = ((per-room-fee * number of rooms) + (square-foot-fee * square footage)) where the per-room-fee and the square-foot-fee is set by the builder. The 2 fees are the same for all 3 of the apartment types. For your spreadsheet, use a per-room-fee of $10 and square-foot-fee of $4. Remember that your spreadsheet should work for any data that is entered. 2) State rebate this monthly rebate is based upon the total size, in square feet (sq. ft.), of all apartments in each building, the total number of rooms. If the total size is greater than 16,000 sq. ft. or the total size is greater than 12,000 sq. ft and the number of rooms is greater than 55, then the rebate is $50 per apartment otherwise it is $60 per apartment. Costs there are 3 costs the builder will incur monthly: loan to pay for construction taxes maintenance 1) The cost of construction will be paid with a loan that will be paid off monthly in 20 years at an interest rate of 7.5%. The cost to build each apartment in the building is a function of the following table: Square foot of the apartment Cost per square foot 0 500 $300 501 700 $265 701 999 $240 1000+ $200 Remember that the loan is calculated on the total construction cost of each building. 2) Taxes the formula for the monthly real estate tax for each building is based on the total monthly rent for that apartment building. The tax rate is 5% for the first $60,000 of rent and 5.75% for any rent over $60,000. 3) Maintenance if the total square footage of the building exceeds 15,000 sq. ft. and the total income is greater than $68,000 per month, the maintenance cost incurred by the builder is $2 per square foot of space. If not, the maintenance cost is $2.25 per square foot of space. The minimum cost of maintenance is $35,000 per month. That is, the smallest amount paid per month for maintenance is $35,000. Be sure to display the following values for each building type: 1) Monthly Rent 2) Monthly State Rebate 3) Monthly Income 4) Monthly Loan Payment to Pay for Construction 5) Monthly Taxes 6) Monthly Maintenance 7) Monthly Cost 8) Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: Largest Monthly Profit Average Monthly Profit Notes 1) The analysis should produce monthly numbers. 2) All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 3 decimal places. 3) Be sure to have an assumptions/constants section. 4) Use absolute addresses where appropriate. 5) Make sure the spreadsheet is laid out in an organized, logical manner. 6) Use text wrapping for column headings that are too wide. 7) Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values.
Solved by X. J. in 18 mins

Leave a Comment

avatar