Gudaha Microsoft Excel , shaqada DISC waa shaqo maaliyadeed, ujeeddadeeduna waa soo celinta sicir-dhimista amniga. Qaabka shaqada DISC waa DISC( settlement, maturity, pr, redemption, [basis]).

Waa maxay macnaha shaqada Excel DISC?

Isku dhafka shaqada DISC waa hoos.

• Dejinta^(Settlement) : Taariikhda dejinta ammaanku waa marka amniga laga iibiyo iibsadaha taariikhda soo saarista ka dib. Waa loo baahan yahay.
• Qaan^(Maturity) -gaarnimada : Taariikhda qaan-gaarnimada waa taariikhda marka ammaanku dhaco. Waa loo baahan yahay.
• Pr : Qiimaha Nabadgelyada^(Security) ee $100 ee qiimaha wejiga Waa loo baahan yahay.
• Furashada^(Redemption) : Qiimaha furashada amniga 100kiiba qiimaha waji Waa loo baahan yahay.
• Saldhig^(Basis) : Nooca maalinta tirinta ee la isticmaalayo. Waa ikhtiyaari.

Sidee u isticmaashaa qaacidada shaqada ee Excel ?

Ma aha hawl adag in la isticmaalo; Way fududahay ilaa inta aad garanayso qaacideeda. Tababarkan, waxaan kaga hadli doonaa sida loo isticmaalo shaqada DISC ee Excel .

Waa maxay sababta DISC u soo celiso #VALUE?

Gudaha Microsoft Excel , shaqada DISC waxay soo celin doontaa qiimaha qaladka # Qiimaha^(Value) haddii amniga ama qaan-gaarka uusan ahayn nambar taariikh taxane ah.

Sida loo isticmaalo shaqada DISC gudaha Excel

Si aad u isticmaasho shaqada DISC gudaha Excel , raac tillaabooyinka hoose.

1. Fur Excel
2. Samee miis ama isticmaal miiska jira
3. Ku qor qaacidada shaqada DISC unugga aad rabto inaad natiijada dhigto
4. Riix Gelida si aad u aragto natiijada

Bilaw Microsoft Excel .

Samee miis ama isticmaal miiska jira.

Ku qor shaqada =DISC(B2, B3, B4, B5) unugga aad rabto inaad natiijada dhigto.

• B2 waa dejinta marka amniga laga iibiyo iibsadaha taariikhda soo saarista ka dib.
• B3 waa qaan- gaarnimada^(Maturity) , taariikhda marka ammaanku dhaco.
• B4 waa qiimaha Nabadgelyada^(Security) 100$ kiiba.
• B5 waa qiimaha madax furashada amniga halkii $100 qiimaha wejiga.

Kadib riix furaha geli si aad u aragto natiijada.

Waxaa jira laba hab oo kale oo loo isticmaalo   shaqada DISC gudaha Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidixda sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qayb^{(Select a Category)} , ka dooro Maaliyadda^{(Financial )} sanduuqa liiska.

Qaybta Dooro Shaqo^{(Select a Function)} , ka dooro hawsha DISC liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

• Qaybta Dejinta^{(Settlement )} , geli sanduuqa gelitaanka unugga B2 .
• Qaybta qaan^{(Maturity )} -gaadhka, geli sanduuqa gelitaanka unugga B3 .
• Qaybta Pr , geli sanduuqa gelitaanka unugga B4 .
• Qaybta Furashada^{(Redemption )} , geli sanduuqa gelitaanka unugga B5 .

Kadib dhagsii OK .

Habka labaad waa in la gujiyo tabka^{(Formulas )} foomamka oo aad gujiso badhanka maaliyadeed ee kooxda ^{(Financial )}maktabadda Function^{(Function Library)} .

Liiska hoos-u-dhaca, dooro DISC .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada DISC gudaha Excel .

How to use the DISC function in Excel

In Microsoft Excel, the DISС fυnction іs a Financial function, and its purpose is to return a discount rate for secυrity. The formula for the DISC fυnction is DISC( settlement, maturity, pr, redemption, [basis]).

What is Excel DISC function syntax?

The syntax for the DISC function is below.

• Settlement: The security settlement date is when the security is traded to the buyer after the issue date. It is required.
• Maturity: The maturity date is the date when the security expires. It is required.
• Pr: The Security price per $100 face value. It is required.
• Redemption: The security’s redemption value  per $100 face value. It is required.
• Basis: The type of day count basis to use. It is optional.

How do you use the function formula in Excel?

It is not a complicated function to use; it is pretty easy as long you know its formula. In this tutorial, we will discuss how to use the DISC function in Excel.

Why does DISC return #VALUE?

In Microsoft Excel, the DISC function will return an #Value error value if security or maturity is not a serial date number.

How to use the DISC function in Excel

To use the DISC function in Excel, follow the steps below.

1. Launch Excel
2. Create a table or use an existing table
3. Type the formula for the DISC function into the cell you want to place the result
4. Press Enter to see the result

Launch Microsoft  Excel.

Create a table or use an existing table.

Type the function =DISC(B2, B3, B4, B5) into the cell you want to place the result.

• B2 is the Settlement when the security is traded to the buyer after the issue date.
• B3 is the Maturity, the date when the security expires.
• B4 is the Security price per $100 face value.
• B5 is the security’s redemption value per $100 face value.

Then press the enter key to see the result.

There are two other methods to use the  DISC function in Excel.

Method one is to click the fx button on the top left of the excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Financial from the list box.

In the section Select a Function, choose the DISC function from the list.

Then click OK.

A Function Arguments dialog box will open.

• In the Settlement section, input into the entry box the cell B2.
• In the Maturity section, input into the entry box the cell B3.
• In the Pr section, input into the entry box the cell B4.
• In the Redemption section, input into the entry box the cell B5.

Then click OK.

Method two is to click the Formulas tab and click the Financial button in the Function Library group.

In the drop-down menu, select DISC.

A Function Arguments dialog box will appear.

We hope this tutorial helps you understand how to use the DISC function in Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel