I'm building my first complex (for me) Spreadsheet and I'm really tripped up at one part. This is for keeping track of eBay sales. I have a column for the "sold" price, eBay fees (9%), PayPal fee 2.9% +.30, and a "net profit" column….However, when I have an international sale PayPal charges 3.9% +.30. Right now I have it so that when I enter in the sold price, the spreadsheet calculates the eBay fees, PP fees at 2.9% +.30, and gives me the net profit. What can I do to make it calculate 3.9% +.30 for international sales? I'd like to keep it as simple as possible and not add many more columns. Is it possible to keep just one PP fees column but have two different formulas in there? And then maybe have two different "sold" columns; one international, one domestic? I've been looking at this too long and probably overthinking it.
Google-sheets – Is it possible to keep just one PP fees column but have two different formulas in there
google sheets
Related Solutions
Use the conditional format option in the menu format:
Make sure to select the complete column, when applying the conditional format.
See screenshot from the example file I prepared:
Example file: Conditional Formatting. Try to add some numbers yourself add see the result. Be sure to check the settings under Format> Conditional formatting... in the menu.
Another way of doing it is by using the following formula.
Formula
=IFERROR(QUERY(A2:C8, "SELECT C WHERE B <=" & E2 & "ORDER BY C ASC LIMIT 1"),"")
Explained
The complete range is set to be the data range. The quasi SELECT statement first filters on items that are less or equal to the selected min qty. Then the items are ordered ascendingly and limited to only one result. The IFERROR catches the error if no value has been entered.
Screenshot
Example
I've prepared an example file for you: price bracket
Related Topic
- Google-sheets – Add timestamp to two different columns in Google Spreadsheets
- Google-sheets – Apply formula when other is modified
- Google-sheets – Calculate difference between numbers in 2 columns row-by-row in a spreadsheet
- Google-sheets – Google Spreadsheet Percentage of Price in Column
- Google-sheets – Automatically store updated GOOGLEFINANCE values with a script
- Google-sheets – How to combine two different columns
Best Answer
It is simple to do what you want.
Use an
IF(logical_expression, value_if_true, value_if_false)statementthe net profit would be the
sold price -minus the "ebayfee" cell - the "pp fee" cell.