0
How do you write an excel formula to find the gross margin percent if A1 is cost and B1 is retail?
Wiki User
∙ 14y ago
"=((B1-A1)/B1)*100" alternatively if you format the cell as a %, it would just be "=(b1-a1)/b1"
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the formula for Net Operating Margin in Excel?
=(total revenue- total expenditures)/revenue. you get a percentage.
What is the Excel formula for the selling price if you have cost and margin?
The selling price is the cost plus the margin. If you know the margin as a fixed value and the cost was in cell A2 and the margin in B2, in C2 you could put the following formulas: =A2+B2 If the margin is a percentage of the cost and the margin is in B2, then the formula would be: =A2+A2*B2
How do you calculate tax 19 percent of R cost in excel?
Multiply the retail cost by 0.19
Which is the column separator in excel?
column margin
How do you convert degrees into slope in Excel?
To convert 'D' degrees into a percent slope, you could use the Excel formula:= 100 * TAN ( D / 57.296 )
How do i add formula for excel if an answer in box is over 100 percent eg if under 100 percent box is red if over 100 percent box is green?
Use conditional formatting
What keys remove the margin from the source area in Excel?
The Esc key.
What is the text printed in the top margin of each page in excel?
header
What is 12.5 percent in Excel?
12.5 percent can be written with a percent symbol or as a decimal in Excel: 12.5% 0.125
How do you change the page margins to wide or where the top left bottom and right margin is at 1 in excel?
You can change the page margins to wide or where the top left bottom and right margin is at 1 in excel easily. Just got to the top of the screen and select margin options.
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
Where is the formula error button in Excel 2007?
There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.
