Tracheitis like other respiratory tract infections, especially laryngitis and bronchitis, may result in very similar signs and symptoms. 1  Retrosternal pain or discomfort (breastbone pain) 2  Dry, painful cough â deep and bark-like in nature. 3  Dysphonia (hoarse voice)  Stridor (abnormal breathing 1  sound) Sore throat. 2  Fever. Painful swallowing (odynophagia)
Enter Redemption Price: into cell A4 and the corresponding price into cell B4, $100 in this example. Now use the corresponding Excel function, DISC, to calculate the discount rate for the bond. In cell A5, enter Discount Rate: to label the value in cell B5.The function DISC takes in specific parameters in a specific order of settlement date, maturity date, price and redemption price. In cell B5 enter =DISC(B1, B2, B3, B4). The discount rate is determined to be 1%.You can calculate the discount factor over time by using the formula: D = 1Ã·(1+r)^n, where D is the discount factor, r is the discount rate, and n is the number of years.he discount rate is determined to be 1%. You can calculate the discount factor over time by using the formula: D = 1Ã·(1+r)^n, where D is the discount factor, r is the discount rate, and n is the number of years.
Ensure the cell where you want to store the percentage is selected and click inside the Formula field. Step 5. Type =Cell1/Cell2 (without the quotations) and press Enter to find the percentage of the two cells. Replace Cell1 and Cell2 with the correct cell numbers -- B2 and C4 for example.Step 6. Press Ctr-S to save the changes to your spreadsheet, if desired.tep 1. Open the spreadsheet you want to edit in Excel and locate the two cells. Locate the cell where you want to store the percentage. Step 2. Right-click the cell where you want to store the percentage and choose Format Cells from the context menu to open the Format Cells window.