Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | |||
3 | Value | 25% | 65% | 20% | 51% | 30% | ||
4 | Positive | 48% | 48% | 48% | 48% | 48% | ||
5 | Break Even | 4% | 4% | 4% | 4% | 4% | ||
6 | Negative | 48% | 48% | 48% | 48% | 48% | ||
7 | ||||||||
8 | Negative (>=52%) Break Even (>=48%) Positive (<48%) | |||||||
9 | ||||||||
10 | ||||||||
Sheet5 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A8 | A8 | =CONCATENATE( A6&" (>="&TEXT(B5+B4,"0%")&")"& CHAR(13)&CHAR(10)&A5&" (>="&TEXT(B4,"0%")&")"& CHAR(13)&CHAR(10)&A4&" (<"&TEXT(B4,"0%")&")") |