ExcelBanter - Formula after division

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula after division (https://www.excelbanter.com/excel-discussion-misc-queries/246564-formula-after-division.html)

gemcauley

Formula after division

Need to display the gross margin as a percentage (easy enough) but after
dividing my 2 known amounts I need to subtrack several cells to get the
correct value. What is the formula string to subtract these cells?

Eduardo

Formula after division

Hi,
not sure what you want to do without an example but try

=(A2/B1)-C2-D2

"gemcauley" wrote:

Need to display the gross margin as a percentage (easy enough) but after
dividing my 2 known amounts I need to subtrack several cells to get the
correct value. What is the formula string to subtract these cells?

All times are GMT +1. The time now is 12:21 PM.