Example: column A1 is $35.00. I want column B1 to be a percentage markup value dependent on the value in A1 (i.e.: 75%). So if A1 is between $1 and $10, B1 = 75%; if between $11 and $20, B1 = 60% and so on.
How can I achieve this?
Google-sheets – Google spreadsheet cell outcome dependent on another cell’s range
formulasgoogle sheets
Related Solutions
Answered I received in the Google Support Forum:
=counta(iferror(filter(B:B,A:A="name1",B:B="yes")))
In order to reproduce the result, given by the OP, you need to use this formula.
Formula
=SUM(FILTER(C2:C,B2:B=D6,A2:A>=D4,A2:A<=D5))
Note
Apart from that, you need to change the end date from 7/20/2012 to 7/23/2012
Screenshot
Example
See example file I prepared: SUM with FILTER
Related Topic
- Google-sheets – How to use a named column in a calculation based on a cell value in Google Spreadsheet
- Google Sheets – Check Cell Value and Subtract Based on Outcome
- Google Sheets – Get Cell or Range Reference Dynamically
- Google-sheets – Suming values in a column if value in cell next to it matches another cell
- Google Sheets – Assign Value to Cell Based on Another Cell’s List
- Google Sheets – Remove Values in a Range if They Appear in Another Range
Best Answer
I believe you are looking for a nested if statement. Put this formula in B1 and then drag it down as far as needed...
=IF(AND(A1>1,A1<10), A1*.75,(IF(AND(A1>10,A1<20), A1*.60, (IF(AND(A1>20,A1<30), A1*.50, (IF(test, then_true, otherwise_value))))))
I just did the first 3 iterations. You can continue from there and set the values as needed. Make sure to match left and right parenthesis.
I hope this helps.