Spreadsheet: 841955d1694074808-allocate-amount-based-on-multiple-criteria-allocate-amount-based-on-criteria
Sheet: Sheet1

Code | Grade | Amount | Nationality | Company
1626 | 13 |  | Non-Saudi | MBA
1775 | 11 |  | Non-Saudi | MBA
5745 | 7 |  | Non-Saudi | MBA
6989 | 7 |  | Non-Saudi | MBA
7072 | 11 |  | Non-Saudi | MBA
7380 | 6 |  | Non-Saudi | MBA
7406 | 8 |  | Non-Saudi | MBA
1001 | N/A |  | Saudi | ABC |  |  |  | Criteria
1002 | N/A |  | Non-Saudi | ABC |  |  | 1 | Applies only to Company = "NMC"
1003 | N/A |  | Non-Saudi | ABC |  |  | 2 | IF(OR([@Nationality]="Saudi",[@Code]=7520,[@Code]=7894,[@Code]=8248),0,Amount)
1004 | N/A |  | Non-Saudi | ABC |  |  | 3 | If [NAME] is 10 And Above then Amount 763
A1000 | N/A |  | Saudi | XYZ |  |  | 4 | If [NAME] is 7 And Equal to 9 then Amount 813
A1001 | N/A |  | Saudi | XYZ |  |  | 5 | If [NAME] is below 7 Then Amount 779
A1002 | N/A |  | Saudi | XYZ
1555 | 8 |  | Non-Saudi | NMC
1592 | 10 |  | Non-Saudi | NMC
1783 | 12 |  | Non-Saudi | NMC
1810 | 10 |  | Saudi | NMC
3797 | 11 |  | Non-Saudi | NMC
4855 | 13 |  | Non-Saudi | NMC
4863 | 10 |  | Saudi | NMC
4923 | 6 |  | Non-Saudi | NMC
5867 | 9 |  | Non-Saudi | NMC
5932 | 8 |  | Non-Saudi | NMC
5956 | 8 |  | Non-Saudi | NMC
6000 | 15 |  | Non-Saudi | NMC
6059 | 11 |  | Non-Saudi | NMC
6081 | 12 |  | Non-Saudi | NMC
6088 | 8 |  | Saudi | NMC
6483 | 9 |  | Non-Saudi | NMC
6914 | 11 |  | Non-Saudi | NMC
7054 | 11 |  | Non-Saudi | NMC
7078 | 12 |  | Non-Saudi | NMC
7083 | 12 |  | Non-Saudi | NMC
7095 | 9 |  | Saudi | NMC
7391 | 9 |  | Non-Saudi | NMC
7393 | 10 |  | Saudi | NMC
7499 | 12 |  | Saudi | NMC
7513 | 8 |  | Non-Saudi | NMC
7520 | 10 |  | Non-Saudi | NMC
7537 | 11 |  | Non-Saudi | NMC
7544 | 10 |  | Saudi | NMC
7549 | 6 |  | Saudi | NMC
7550 | 6 |  | Saudi | NMC
7552 | 6 |  | Saudi | NMC
7553 | 6 |  | Saudi | NMC
7554 | 6 |  | Saudi | NMC
7559 | 7 |  | Saudi | NMC
7560 | 7 |  | Saudi | NMC
7563 | 7 |  | Saudi | NMC
7564 | 12 |  | Saudi | NMC
7565 | 6 |  | Saudi | NMC
7580 | 11 |  | Non-Saudi | NMC
7719 | 9 |  | Saudi | NMC
7723 | 10 |  | Non-Saudi | NMC
7725 | 6 |  | Saudi | NMC
7726 | 6 |  | Saudi | NMC
7727 | 6 |  | Saudi | NMC
7732 | 7 |  | Saudi | NMC
7733 | 6 |  | Saudi | NMC
7734 | 6 |  | Saudi | NMC
7736 | 12 |  | Saudi | NMC
7750 | 8 |  | Non-Saudi | NMC
7752 | 7 |  | Saudi | NMC
7758 | 7 |  | Saudi | NMC
7759 | 6 |  | Saudi | NMC
7760 | 6 |  | Saudi | NMC
7761 | 6 |  | Saudi | NMC
7762 | 6 |  | Saudi | NMC
7763 | 7 |  | Saudi | NMC
7764 | 6 |  | Saudi | NMC
7765 | 7 |  | Saudi | NMC
7766 | 7 |  | Saudi | NMC
7783 | 13 |  | Non-Saudi | NMC
7808 | 8 |  | Saudi | NMC
7856 | 6 |  | Saudi | NMC
8010 | 9 |  | Non-Saudi | NMC
8011 | 11 |  | Non-Saudi | NMC
8012 | 12 |  | Non-Saudi | NMC
8026 | 10 |  | Non-Saudi | NMC
8028 | 12 |  | Non-Saudi | NMC
8029 | 8 |  | Saudi | NMC
8030 | 8 |  | Non-Saudi | NMC
8032 | 9 |  | Saudi | NMC
8035 | 8 |  | Non-Saudi | NMC
8114 | 7 |  | Non-Saudi | NMC
8115 | 7 |  | Non-Saudi | NMC
8116 | 5 |  | Non-Saudi | NMC
8117 | 10 |  | Non-Saudi | NMC
8119 | 6 |  | Saudi | NMC
8139 | 11 |  | Saudi | NMC
8167 | 10 |  | Non-Saudi | NMC
8170 | 10 |  | Non-Saudi | NMC
8171 | 11 |  | Non-Saudi | NMC
8172 | 10 |  | Non-Saudi | NMC
8192 | 12 |  | Non-Saudi | NMC
8193 | 10 |  | Saudi | NMC
8208 | 10 |  | Saudi | NMC
8212 | 16 |  | Non-Saudi | NMC
8243 | 8 |  | Non-Saudi | NMC
8248 | 13 |  | Non-Saudi | GSC
8262 | 11 |  | Non-Saudi | NMC
8300 | 7 |  | Saudi | NMC
8309 | 12 |  | Saudi | NMC
8295 | 8 |  | Saudi | NMC
7894 | 8 |  | Non-Saudi | NMC