I thought it nikon scope for 300 win mag would look something like this: (F/100*70).
Or, if the discount is different in each row, use something like (F3/100*X3) where column X holds the discount value for that particular row.
How do I mark this thread as solved?
Thank you in advance guys, regards.There are half a dozen other ways of copying a cell/formula down a column (or across a row).In this case, Excel first divides the discounted price in D5 (59.5) by the original price in C5 (70) to get.85, which is then subtracted from 1: 1-(59.5/70) 1-0.85.15, note: the result is a decimal value, and must be formatted using the Percentage.Test the checkbox, and adjust the column width to fit the total amount to be repaid numbers If you plan to protect the sheet, unlock cells B2:B7, so the variables can be changed, and unlock cell C1, which is linked to the checkbox.A2-(B2*A2) (the Cell A2 indicates the original price, and the Cell B2 stands the discount rate of the item, you can change them as you need press.Enter the following text and formulas: A8: Loan Comparison Worksheet A9: "Amounts Shown Are " IF(C1 Total To Be Repaid Monthly Payments The heading in cell A9 will change, depending on the checkbox setting.Add the CheckBox A checkbox from the Form controls will let you see loan payments, or total amount to be paid.Calculate discount price with formula in Excel.
Group 3 Copy cells A18:B22 Click on cell A24, and paste, to create the third group of row headings, showing the interest rate with two increments.
You can use this technique in other workbooks too - for example, use a checkbox to specify if tax should be included, or to add an employee discount to the price.
There are no macros in the workbook.
Change to Solved Click Save Register To Reply.The access forum it's under thread tools, but couldn't see it there.In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with vlookup and index match, count and sum with criteria, dynamically rank values, and create dynamic ranges.Register To Reply, 07:48 AM #2, re: calculate discount for full column.The cell references will adjust in each row, if you use relative references.Enter this formula in cell B18: B18: B12B5 Select cell B18, and copy it down to cell B22, to complete the second group of row headings, showing the interest rate with one increment.I am trying to create a formula for a column that will display a total with discount misused.