After searching through several sites this seemed to be the best area for Google Spreadsheet questions and after browsing through the tag google-spreadsheets 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: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 DPercent off is input in Column CColumn 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)?
Google Spreadsheet Percentage of Price in Column
google spreadsheets
You can use the following in your End Price column:=FullPrice-ROUND(FullPrice*PercentDiscount,2)FullPrice = Column with the full price.PercentOff = Column with the percentage discount you want to apply.