Spreadsheet: 841023d1693288584-help-with-if-formula-with-combination-of-or-and-and-sattement1a-28082023
Sheet: Sheetname

Order Date | Order | Status | Activity Buy/Sell | Product | Qty | Amount | Stock Level  Desk | Stock Level  Desk- S | Total Value Desk (£) | Total Value Desk -S  (£)
Opening Stock |  |  |  |  |  |  | 200 | 187 | 7600 | 5200
2021-01-02 00:00:00 | [PHONE] |  | Buy | DESK | 2 | 204.75 | if cell E3 is equal to "Desk" and cell d2 is equal to "buy" then cell I3 shoul show result of (F3+H2)  OR if cell E3= "desk" and cell [NAME] is equal to "Sell" then Cell I3 should show result as  (F2-H2)
2021-01-03 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 135.36
2021-01-04 00:00:00 | [PHONE] |  | Buy | DESK | 5 | 227.5
2021-01-04 00:00:00 | [PHONE] | delivered | Buy | DESK -S | 1 | 227.5
2021-01-06 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 267.91
2021-01-07 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 382.72
2021-01-08 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 546.75
2021-01-09 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 333.52
2021-01-10 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 328.05
2021-01-11 00:00:00 | [PHONE] | cancel | Sell | DESK | 3 | 5350
2021-01-12 00:00:00 | [PHONE] | pending | Sell | DESK | 3 | 4345.6
2021-01-13 00:00:00 | [PHONE] |  | Buy | DESK | 2 | 146.63
2021-01-14 00:00:00 | [PHONE] |  | Buy | DESK | 5 | 225.58
2021-01-15 00:00:00 | [PHONE] | delivered | Sell | DESK | 6 | 283.98
2021-01-16 00:00:00 | [PHONE] | delivered | Sell | DESK | 6 | 466.08
2021-01-17 00:00:00 | [PHONE] | delivered | Sell | DESK | 6 | 314.33
2021-01-18 00:00:00 | [PHONE] | delivered | Sell | DESK | 6 | 541.95
2021-01-19 00:00:00 | [PHONE] | confirmed | Sell | DESK | 8 | 5300
2021-01-20 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5310
2021-01-22 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5300
2021-01-23 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5290
2021-01-24 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5250
2021-01-25 00:00:00 | [PHONE] | cancel | Sell | DESK | 9 | 4870
2021-01-26 00:00:00 | [PHONE] | cancel | Sell | DESK | 9 | 5280
2021-01-27 00:00:00 | [PHONE] | cancel | Sell | DESK | 9 | 5304.74
2021-01-28 00:00:00 | [PHONE] | cancel | Sell | DESK | 9 | 5304.74
2021-01-29 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5293.91
2021-01-30 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 170.24
2021-01-31 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 136.19
2021-02-01 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 113.49
2021-02-02 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 436.36
2021-02-03 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 272.73
2021-02-04 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 313.088
2021-02-05 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 304.36
2021-02-06 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 545.45
2021-02-07 00:00:00 | [PHONE] | pending | Sell | DESK | 1 | 5340
2021-02-08 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 163.16
2021-02-09 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 193.97
2021-02-10 00:00:00 | [PHONE] |  | Buy | DESK | 5 | 114.1
2021-02-11 00:00:00 | [PHONE] |  | Buy | DESK | 5 | 228.2
2021-02-12 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 382.85
2021-02-13 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 493.65
2021-02-14 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 329.1
2021-02-15 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 235.85
2021-02-16 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 405.89
2021-02-17 00:00:00 | [PHONE] | delivered | Sell | DESK | 5 | 548.5
2021-02-18 00:00:00 | [PHONE] | pending | Sell | DESK | 5 | 5375
2021-02-19 00:00:00 | [PHONE] | confirmed | Sell | DESK | 5 | 5300
2021-02-20 00:00:00 | [PHONE] | pending | Sell | DESK | 5 | 3285.51
2021-02-21 00:00:00 | [PHONE] | cancel | Sell | DESK | 5 | 3285.51
2021-02-22 00:00:00 | [PHONE] | cancel | Sell | DESK | 3 | 3285.51
2021-02-23 00:00:00 | [PHONE] | cancel | Sell | DESK | 3 | 4940
2021-02-24 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 193.78
2021-02-25 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 136.79
2021-02-26 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 547.95
2021-02-27 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 380.28
2021-02-28 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 328.77
2021-03-01 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 273.98
2021-03-02 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5369.91
2021-03-03 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 148.62
2021-03-04 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 132.49
2021-03-05 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 288.11
2021-03-06 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 221.62
2021-03-07 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 387.84
2021-03-08 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 193.05
2021-03-09 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 218.33
2021-03-10 00:00:00 | [PHONE] |  | Buy | DESK | 1 | 229.82
2021-03-11 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 552.55
2021-03-12 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 318.27
2021-03-13 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 331.53
2021-03-14 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 359.16
2021-03-15 00:00:00 | [PHONE] | delivered | Sell | DESK | 1 | 522.71
2021-03-16 00:00:00 | [PHONE] | cancel | Sell | DESK | 9 | 4530.91
2021-03-17 00:00:00 | [PHONE] | confirmed | Sell | DESK | 9 | 5400
2021-03-18 00:00:00 | [PHONE] | confirmed | Sell | DESK | 7 | 4400
2021-03-19 00:00:00 | [PHONE] | cancel | Sell | DESK | 6 | 2320.71
2021-01-04 00:00:00 | 1609750087 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609750233 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609750361 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609750500 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609754749 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609756395 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609768733 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609846849 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609925223 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609925299 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609925527 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609925667 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609925762 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609926158 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609930672 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1609941144 | delivered | Buy | DESK -S |  | 227.5
2021-01-04 00:00:00 | 1610018542 | delivered | Buy | DESK -S |  | 227.5