Assumptions and Threshold?

[Vonnie Arellano]

I have as assignment that requires an IF statement: =IF(PercentChange>Threshold,PercentChange-Threshold,0) I don't understand the "threshold" concept. There is only a statement that Assumptions: Threshold - 10%.

Can anyone give me some information about using assumptions or thresholds?

Thank you!

[protonLeah]

THRESHOLD 1: A level, point, or value above which something is true or will take place and below which it is not or will not.
THRESHOLD 2: end, boundary; specifically the place or point of entering or beginning.

Therefore, if the threshold is 10%, anything greater would cause/trigger some action, result or calculation to occur. Thus, "threshold" is not a concept, it is, rather, a switch that is either on or off.
----------------------
GIVEN:
Threshold: 15%
%change: 21 %
Action: perform calculation since %∆ > Threshold

GIVEN:
Threshold: 7.5%
%change=1.1%
Action: Do nothing (i.e., return the threshold value since %∆ is less)

[Vonnie Arellano]

OK. That makes sense. How do set up this threshold?

[ChemistB]

Could be a lot of things. Hard to tell without an example of your data (upload an example spreadsheet). For example, maybe you are looking for an IF statement like so where your Threshold in a constant in cell A1
=IF($A$1>10%, SUM(B1:B10),"")
Hope that helps.

[ChemistB]

Reviewing your original post
Assuming threshold in A1 and Percent change in B1
=IF(B1>A1,B1-A1,0)

[Vonnie Arellano]

Reviewing your original post
Assuming threshold in A1 and Percent change in B1
=IF(B1>A1,B1-A1,0)

I have been given this formula:
=IF(PercentChange>Threshold,PercentChange-Threshold,0)

Then I am supposed to make a mini chart that shows:

Assumptions:
Threshold 10%

So, I have to get the title of "threshold" to pick up the value of 10% in this formula.

Hope that helps.

[protonLeah]

So, I have to get the title of "threshold" to pick up the value of 10% in this formula.

NO! That's not what you are supposed to do.

You are supposed to create a worksheet with:
1. A cell containing the threshold value (a number in a cell)
2. a column with of values the percent change values
3. A column with the formula (given above) that calculates the difference between the so called threshold value and the percent changes. and
4. Use your column data to create a graph.

Have you tried to create your workbook?

So, I have to get the title of "threshold" to pick up the value of 10% in this formula.

Faldercarb. Titles don't "pick up" anything, they are just labels in the top cells of the columns, put there to explain what the numbers below it are. So, your worksheet should have a column with "Threshold" in the first cell of some column, probably A1, "Percent Change" in, say B1 and Difference in C1
Then in A2 you would have 10%, but in B2 to B10 (or more) you should have values for the actual percent changes, where ever they come from. The formula in C2... will calculate the difference. Finally, you will use columns B & C for your graph.

Have you tried to create your workbook?

Where's your work?...