ROMAN formula In EXCEL SHEET

This  Formula is simple to use,it is  Math based Excel formula which performs the following function.

• Convert a value, written in Arabic format (standard numeral system) and converts it into the  Roman Numeral system as text. 

SYNTAX OF ROMAN FORMULA

                                               =ROMAN(number, [form])

The ROMAN formula syntax has the following arguments:

• The number argument. This can be a set value, or a cell address, of the Arabic numeral that you wish to convert.

• The optional argument, form. This is a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases. 
• Refer to the following list. 

1. Form Type
2.  0 or omitted Classic.
3. 1,2,3 More concise
4. 4 Simplified.
5. TRUE Classic. 
6. FALSE Simplified.

HAPPY BLOGGING!!

Read More

REPT Function in EXCEL SHEET

Let’s assume you needed to replicate a certain symbol over a 1000 times in a single cell. Now, you can Repeats text a given number of times.so a special function is provided by the EXCL.

•   Use REPT to fill a cell with a number of instances of a text string.

Syntax Of REPT

=REPT(text, number_times) 

 Where,

• ‘text’ is the text that you intend to repeat and
•  The ‘number_of-times’ is a positive number specifying the number of times the text should be repeated.

 YOU CAN SEE DEMO SLIDE BELOW

  
HOPE IT IS HELPFUL FOR YOU.
FOR MORE TIPS OF EXCEL SHEET

• How To Add A Check Box in EXCEL SHEET ?
• What is IF Formula in EXCEL SHEET ?
• How to add drop down list in excel sheet ?

Read More

How To Add A Check Box in EXCEL SHEET ?

If you want to include a form into you sheet,To add a check box in Excel, You need to follow some instructions mentioned below :-

1. Go to the Developer tab
2. Select Insert
3. Form Control,
4. Check box. 
5. Drag the shape to add your text box.
6. To edit the location, text, appearance, and options - right click on the check box.  

 YOU CAN ALSO READ TRICKS OF EXCEL SHEET

1. What is IF Formula in EXCEL SHEET ?
2. How to add drop down list in excel sheet ?  

After following these instructions you got the output shown below:-

  

Read More

What is IF Formula in EXCEL SHEET ?

The IF formula is  used to determine whether a condition specified by you turns out to be

•  True

•  False. 

This can be useful if you need to evaluate a decision based on supplied data.

Syntax for the IF formula

The syntax for the IF formula is as follows: IF(logical_test, [value_if_true], [value_if_false])
  

What is logical_test ?

• The logical_test is the condition that you would be checking against. In this case, we are checking to see if the product does not have a tax attached to it.

What is value_if_true ?

• The value_if_true is the value displayed if the test turns out to be true. In our case, we calculate the final sales of the item. (Multiply the unit price by the amount of units sold.)

What is value_if_false ?

• The value_if_false is the value displayed if the test turns out to be false. In our case, we calculate the total sales, then add the tax to determine the final sales.

 If you want to know other tricks about excel sheet

• How to add drop down list in excel sheet ?
   

Read More

How to add drop down list in excel sheet ?

EXCEL SHEET sometimes said as balance sheet is basically a way to maintain the fact & figures or all the documentation related to the organization .

If you are struggling to add drop-down list in excel sheet, then 

for example: rows have following values a, b, c and d. And you want a drop down list on top of these rows to display all these mentioned values then  we need to follow the below steps
.
1. Click on the Data tab (present on top of the excel) and click on Data validation tab.

2. Under setting tab (default tab in data validation window), and select List item from Allow drop down field.

Note: Make sure you have selected the cell in excel where you want to add the drop down list 
field.

 

HAPPY BLOGGING

 

Read More