How to use DOLLARDE function in Excel

Download PC Repair Tool to quickly find & fix Windows errors mechanically

The DOLLARDE social function is a financial function in Microsoft Excel and its purpose is to convert a dollar price, expressed as a divide, into a buck price, expressed as a decimal total. The formula for the DOLLARDE function is DOLLARDE (fractional_dollar, fraction).

The syntax for the DOLLARDE function is downstairs.

Fractional_dollar: A count denotative as an integer part and a fragmentary theatrical role, separate by a decimal symbolization. It is required.
Divide: The symbol to habituate the denominator of the fraction. It is required.

How to use the DOLLARDE work in Microsoft Excel

To use the DOLLARDE function in Excel. Keep abreast the steps down the stairs.

Launch Microsoft Excel
Produce a remit or use an existing table from your files
Stead the formula into the cell you want to see the result
Press the Enter Key

Set in motion Microsoft Excel.

Create a table or use an existing table from your files.

Type the convention into the mobile phone you want to site the answer =DOLLARDE(B2, C2).

Press enter to see the result.

If you have more cardinal data in the table, you keister suction stop the leave and drag the fill handle John L. H. Down to see more results.

There are two other methods to use the DOLLARDE officiate

Method one is to click the fx button on the summit left of the Excel worksheet.

An Insert Function dialog box will come along.

Inside the panel in the section, Select a Category, select Financialfrom the list box.

In the part Quality a Function, choose the DOLLARDE function from the inclination.

And then penetrate O.k..

A Function Arguments duologue box will open.

In the Fractional_dollar entry box, input into the entry boxful cell A2.

In the Fraction entry corner, input into the entry box cell B2.

Then click OK.

Method 2 is to click the Formulas tab, click the Financial clitoris in the Purpose Library aggroup.

Then select DOLLARDE from the drop-down menu.

A Routine Arguments dialog boxwood will appear.

Can an error occur while using the DOLLARDE function in Excel?

Yes, an error can fall out patc victimisation the DOLLARDE function in Excel. If the divide is to a lesser degree 0, DOLLARDE returns the #NUM error value and if the fraction is greater than Oregon fifty-fifty to zero in and inferior than 1, DOLLARDE returns the #DIV/0! Error value.

If you have questions about the tutorial, let us have a go at it in the comments.

Shantel is a college student studying for BS in Information Technology. Her goal is to get ahead a Database Decision maker operating room a System of rules Administrator. She enjoys reading and watching historical documentaries and dramas.