After searching through several sites this seemed to be the best area for Google Spreadsheet questions and after browsing through the tag and searching for price I didn't see this asked before. Closest question found was How to write this Google Spreadsheet percentage calculation function?. So here goes, I have a four column spreadsheet that I would like to narrow down to three columns. The current spreadsheet looks like this:

enter image description here

My end goal is to input Price and Percent Off and then calculate the End Price without having a hidden column, in this case Percent Price. Currently my process is:

  • Price is input in column D
  • Percent off is input in Column C
  • Column B calculates the percentage with =round(D2*C2,2)
  • Column A takes the percent price and subtracts from Price =(D2-B2)

So my question is, how can I get End Price with two columns (Percent Off & Price)?


1 Answer 1


You can use the following in your End Price column:


FullPrice = Column with the full price.

PercentOff = Column with the percentage discount you want to apply.

  • @pnuts that is true, I did edit that area but it gets me closer to the calculation I wanted. Commented Jan 19, 2017 at 17:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.