Spreadsheet: 80066d1280291173-excel-2008-setting-up-logical-compare-conditions-project
Sheet: Sheet4

Item Number | Item Name |  | Profit Per Unit
1 | T-Shirt |  | 5
2 | Dress Shirt |  | 10
3 | Jeans |  | 8
4 | Shorts |  | 6
5 | Slacks |  | 20
6 | Jacket |  | 35
7 | Tie |  | 8
8 | Belt |  | 10
9 | Socks |  | 3
10 | Shoes |  | 20
Month1
 | Week1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4
Item | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit
1 | hot |  |  |  | lame |  |  |  |  |  |  |  |  | yes
2 |  | yes |  |  |  |  |  |  | hot |  |  |  | lame
3 |  | yes |  |  | hot
4 | hot |  |  |  | lame |  |  |  |  | yes
5 |  |  |  |  |  |  |  |  | hot |  |  |  | lame
6 |  |  |  |  |  | yes |  |  | lame
7 | lame |  |  |  | hot
8 |  |  |  |  |  | yes |  |  |  |  |  |  | hot
9 | lame |  |  |  |  |  |  |  |  | yes
10 |  |  |  |  |  |  |  |  | lame |  |  |  | hot | yes
Total
 |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd
Best Week | Worst Week |  |  |  | Total Profit
if(and(week1profit>week2profit, week1profit>week3profit, week1profit> week4profit),week1profit, if(week1profit<week2profit, week2profit>week3profit, week2profit>week4profit),week2profit, if(week1profit<week2profit, week2profit<week3profit, week3>week4profit),week3profit, week4profit)
Month 2
 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4
Item | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit
1 | hot |  |  |  |  |  |  |  | lame |  |  |  |  | yes
2 |  |  |  |  | hot |  |  |  | lame |  |  |  |  | yes
3 |  |  |  |  | lame |  |  |  |  | yes |  |  | hot
4 | lame |  |  |  | lame |  |  |  |  | yes
5 | hot |  |  |  |  | yes |  |  |  |  |  |  | hot
6 |  | yes |  |  |  |  |  |  | hot
7 |  |  |  |  |  |  |  |  | hot |  |  |  | lame
8 | lame |  |  |  |  | yes
9 |  |  |  |  |  |  |  |  |  |  |  |  | lame
10 |  | yae |  |  | hot
Total
 |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd
Best Week | Worst Week |  |  |  | Total Profit
Month 3
 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4
Item | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit | Status | Sale | Sold | Profit
1 | hot |  |  |  | lame |  |  |  |  |  |  |  |  | yes
2 | hot |  |  |  | lame |  |  |  |  |  |  |  |  | yes
3 |  | yes |  |  |  |  |  |  | hot |  |  |  | lame
4 | lame |  |  |  |  |  |  |  | hot
5 | lame |  |  |  |  |  |  |  |  | yes |  |  | hot
6 |  | yes |  |  |  |  |  |  | lame
7 |  |  |  |  | hot
8 |  |  |  |  | hot |  |  |  |  | yes |  |  | lame
9 |  |  |  |  |  | yes
10 |  |  |  |  |  | yes |  |  | lame |  |  |  | hot
Total
 |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd |  |  |  | Additional Items to be orderd
Best Week | Worst Week |  |  |  | Total Profit
 | Totals
[NAME]  Profit
Min Weekly Profit
Average Monthly Profit
Best Month
Worst Month