Spreadsheet: 63440d1264368008-excel-2007-if-function-excel-examples
Sheet: Sheet1

DATE | SHARE PRICE | % CHANGE |  | FILTER
 |  |  |  | 0.01
2005-01-03 00:00:00 | 76.9 |  |  | BUY |  | I start of by buying.
2005-01-04 00:00:00 | 75.93 |  |  | SELL |  | Then as it fell by more than 1% I sell.
2005-01-05 00:00:00 | 74.64 |  |  |  |  | Don't buy here as it doesn't rise
2005-01-06 00:00:00 | 74.8 |  |  |  |  | Don't buy here as it doesn't rise over 1%
2005-01-07 00:00:00 | 71.75 |  |  |  |  | Don't buy here as it doesn't rise
2005-01-10 00:00:00 | 69.17 |  |  |  |  | Don't buy here as it doesn't rise
2005-01-11 00:00:00 | 69.5 |  |  |  |  | Don't buy here as it doesn't rise over 1%
2005-01-12 00:00:00 | 68.53 |  |  |  |  | Don't buy here as it doesn't rise
2005-01-13 00:00:00 | 68.53 |  |  |  |  | Don't buy here as it doesn't rise
2005-01-14 00:00:00 | 67.24 |  |  |  |  | Don't buy here is it doesn't rise
2005-01-17 00:00:00 | 68.85 |  |  | BUY |  | I buy this as it has risen more than 1% from the low price.
2005-01-18 00:00:00 | 67.89 |  |  | SELL |  | Then as it fell by more than 1% I sell.
2005-01-19 00:00:00 | 68.85 |  |  | BUY |  | I buy this as it has risen more than 1% from the low price.
2005-01-20 00:00:00 | 69.5 |  |  |  |  | Don't sell here as it doesn't fall
2005-01-21 00:00:00 | 69.17 |  |  |  |  | Doesn't fall enough
2005-01-24 00:00:00 | 69.17 |  |  |  |  | Doesn't fall enough
2005-01-25 00:00:00 | 70.14 |  |  |  |  | Don't sell here as it doesn't fall
2005-01-26 00:00:00 | 71.1 |  |  |  |  | Don't sell here as it doesn't fall
2005-01-27 00:00:00 | 72.39 |  |  |  |  | Don't sell here as it doesn't fall
2005-01-28 00:00:00 | 72.07 |  |  |  |  | Doesn't fall enough
2005-01-31 00:00:00 | 72.07 |  |  |  |  | Doesn't fall enough
2005-02-01 00:00:00 | 73.03 |  |  |  |  | Don't sell here as it doesn't fall
2005-02-02 00:00:00 | 75.93 |  |  |  |  | Don't sell here as it doesn't fall
2005-02-03 00:00:00 | 79.15 |  |  |  |  | Don't sell here as it doesn't fall
2005-02-04 00:00:00 | 77.86 |  |  | SELL |  | Then as it fell by more than 1% I sell.
2005-02-07 00:00:00 | 78.83 |  |  | BUY |  | I buy this as it has risen more than 1% from the low price.
2005-02-08 00:00:00 | 77.22 |  |  | SELL |  | Then as it fell by more than 1% I sell.
2005-02-09 00:00:00 | 77.22
2005-02-10 00:00:00 | 77.86
2005-02-11 00:00:00 | 78.5 |  |  | BUY |  | I buy this as it has risen more than 1% from the low price (of 77.22)
2005-02-14 00:00:00 | 80.76
2005-02-15 00:00:00 | 80.43
2005-02-16 00:00:00 | 80.43
2005-02-17 00:00:00 | 77.54 |  |  |  |  | CONTINUES ON LIKE THIS
2005-02-18 00:00:00 | 78.18
2005-02-21 00:00:00 | 78.5
2005-02-22 00:00:00 | 74.64
2005-02-23 00:00:00 | 73.36
2005-02-24 00:00:00 | 75.29
2005-02-25 00:00:00 | 75.29
2005-02-28 00:00:00 | 75.61
2005-03-01 00:00:00 | 76.25
2005-03-02 00:00:00 | 77.22
2005-03-03 00:00:00 | 78.83
2005-03-04 00:00:00 | 79.79
2005-03-07 00:00:00 | 79.79
2005-03-08 00:00:00 | 81.08
2005-03-09 00:00:00 | 81.4
2005-03-10 00:00:00 | 80.76
2005-03-11 00:00:00 | 81.4
2005-03-14 00:00:00 | 82.37
2005-03-15 00:00:00 | 82.04
2005-03-16 00:00:00 | 83.97
2005-03-17 00:00:00 | 83.33
2005-03-18 00:00:00 | 83.01
2005-03-21 00:00:00 | 81.24
2005-03-22 00:00:00 | 82.04
2005-03-23 00:00:00 | 82.04
2005-03-24 00:00:00 | 82.69
2005-03-25 00:00:00 | 82.69
2005-03-28 00:00:00 | 82.69
2005-03-29 00:00:00 | 83.65
2005-03-30 00:00:00 | 81.4
2005-03-31 00:00:00 | 81.4
2005-04-01 00:00:00 | 81.72
2005-04-04 00:00:00 | 81.72
2005-04-05 00:00:00 | 82.04
2005-04-06 00:00:00 | 83.01
2005-04-07 00:00:00 | 82.37
2005-04-08 00:00:00 | 82.37
2005-04-11 00:00:00 | 80.76
2005-04-12 00:00:00 | 80.76
2005-04-13 00:00:00 | 81.4
2005-04-14 00:00:00 | 81.4
2005-04-15 00:00:00 | 80.76
2005-04-18 00:00:00 | 77.54
2005-04-19 00:00:00 | 78.18
2005-04-20 00:00:00 | 78.18
2005-04-21 00:00:00 | 77.86
2005-04-22 00:00:00 | 79.79
2005-04-25 00:00:00 | 79.79
2005-04-26 00:00:00 | 78.18
2005-04-27 00:00:00 | 77.54
2005-04-28 00:00:00 | 75.93
2005-04-29 00:00:00 | 75.93