Spreadsheet: 678382d1589862739-writing-a-nested-if-condition-angadi-salary-reduction-employee-list
Sheet: Sheet1

ID | Name | Work Location | Gross | Salary <= 13000 | [NAME] reduced by 20% | 5 Days a Week | Wages Payable
AV00105 | [NAME] | Admin Office | 67000 |  |  | NO
AV00107 | [NAME] | Admin Office | 28028 |  |  | NO
AV00108 | Rekha M | Admin Office | 18524 |  |  | NO
AV00109 | [NAME] | Admin Office | 18524 |  |  | NO
AV00110 | [NAME] | Admin Office | 16500 |  |  | NO
AV00111 | Sathyavathi K S | Admin Office | 19030 |  |  | NO
AV00112 | [NAME] | Admin Office | 24200 |  |  | NO
AV00113 | [NAME] | Admin Office | 27500 |  |  | NO
AV00114 | [NAME] A | Admin Office | 42000 |  |  | NO
AV00115 | [NAME] | Admin Office | 33000 |  |  | NO
AV00116 | Tamarai Kannan S | Admin Office | 44000 |  |  | NO
AV00117 | Santhosh Kumar M | Admin Office | 30250 |  |  | NO
AV00118 | [NAME] | Admin Office | 33000 |  |  | NO
AV00119 | Shakthivel | Admin Office | 33000 |  |  | NO
AV00124 | [NAME] | Admin Office | 60000 |  |  | NO
AV00127 | Kumudha N | Admin Office | 44450 |  |  | NO
AV00128 | Nagaraja A | Admin Office | 16000 |  |  | NO
AV00054 | Shivappa C Ginimav | [NAME] | 61490 |  |  | NO
AV00055 | Kavya S | [NAME] | 31500 |  |  | NO
AV00056 | [NAME] J | [NAME] | 23000
AV00057 | Balasubramanian A P | [NAME] | 34000 |  |  | NO
AV00058 | Chethan Kumar H N | [NAME] | 27620 |  |  | NO
AV00060 | Manjunath R | [NAME] | 21850 |  |  | YES
AV00061 | [NAME] | [NAME] | 19890 |  |  | YES
AV00062 | Manoja T | [NAME] | 23600 |  |  | YES
AV00063 | [NAME] | [NAME] | 17470 |  |  | YES
AV00064 | Ajay Kumar Biswal | [NAME] | 18500 |  |  | YES
AV00065 | Nethra R | [NAME] | 16100 |  |  | YES
AV00066 | Sandhya T | [NAME] | 14750 |  |  | YES
AV00068 | [NAME] | [NAME] | 16900 |  |  | YES
AV00069 | Rashmitha H | [NAME] | 16100 |  |  | YES
AV00070 | Ashwitha A V | [NAME] | 16100 |  |  | YES
AV00071 | [NAME] | [NAME] | 16100 |  |  | YES
AV00072 | [NAME] | [NAME] | 13750 |  |  | YES
AV00074 | Sushma S | [NAME] | 17200 |  |  | YES
AV00123 | [NAME] | [NAME] | 15500 |  |  | YES
AV00120 | Nidhi Pansari | [NAME] | 65000 |  |  | NO
AV00077 | Pallavi S | [NAME] | 35000 |  |  | NO
AV00078 | [NAME] [NAME] | [NAME] | 40000 |  |  | NO
AV00079 | Jayanthi V | [NAME] | 30000 |  |  | NO
AV00080 | Manjuanth B | [NAME] | 30000 |  |  | NO
AV00081 | ChayaKumar Swamy P | [NAME] | 26000 |  |  | NO
AV00082 | Naveen N | [NAME] | 35000 |  |  | NO
AV00083 | [NAME] | [NAME] | 16000 |  |  | YES
AV00084 | Dhanalakshmi | [NAME] | 18000 |  |  | YES
AV00085 | [NAME] | [NAME] | 15000 |  |  | YES
AV00086 | Azaruddin K N P | [NAME] | 15000 |  |  | YES
AV00087 | [NAME] | [NAME] | 15000 |  |  | YES
AV00088 | Lavanya N | [NAME] | 15000 |  |  | YES
AV00089 | [NAME] | [NAME] | 15000 |  |  | YES
AV00090 | Shivaranjini .P | [NAME] | 17000 |  |  | YES
AV00091 | [NAME] | [NAME] | 17000 |  |  | YES
AV00092 | Sharanya A M | [NAME] | 14000 |  |  | YES
AV00093 | Nayana | [NAME] | 16000 |  |  | YES
AV00094 | Kalyan D | [NAME] | 13000 |  |  | NO | 13000
AV00095 | Chandana V | [NAME] | 13000 |  |  | NO | 13000
AV00096 | Pooja J | [NAME] | 12000 |  |  | NO | 12000
AV00097 | Bhavana C S | [NAME] | 12000 |  |  | NO | 12000
AV00098 | Sindhu M | [NAME] | 16000 |  |  | YES
AV00001 | Murganandam D | [NAME] | 27500 |  |  | NO
AV00002 | [NAME] P | [NAME] | 14630 |  |  | YES
AV00003 | Shivananjappa | [NAME] | 18630 |  |  | YES
AV00004 | [NAME] | [NAME] | 17500 |  |  | YES
AV00005 | Roza Mary | [NAME] | 17567 |  |  | YES
AV00006 | [NAME] | [NAME] | 18400 |  |  | YES
AV00007 | Mallikarjuna S R | [NAME] | 19000 |  |  | YES
AV00008 | Krishnan R | [NAME] | 16100 |  |  | YES
AV00010 | Vijaya A | [NAME] | 13200 |  |  | YES
AV00011 | Kaliprasad S | [NAME] | 70280 |  |  | NO
AV00012 | PonnuSwamy | [NAME] | 60500
AV00013 | Elumalai P | [NAME] | 38115 |  |  | NO
AV00014 | Lalitha T S | [NAME] | 22000 |  |  | YES
AV00015 | Surendran Nair | [NAME] | 37950 |  |  | NO
AV00016 | [NAME] R | [NAME] | 22550 |  |  | YES
AV00018 | [NAME] | [NAME] | 19965 |  |  | YES
AV00019 | [NAME] | [NAME] | 27500 |  |  | NO
AV00020 | [NAME] | [NAME] | 39600 |  |  | NO
AV00021 | [NAME] | [NAME] | 20000 |  |  | YES
AV00022 | [NAME] C | [NAME] | 25000 |  |  | NO
AV00029 | Nayanatara | [NAME] | 13000 |  |  | NO
AV00031 | [NAME] | [NAME] | 13000 |  |  | NO
AV00032 | Stephy Honey | [NAME] | 13000 |  |  | NO
AV00033 | Chaithra | [NAME] | 13000 |  |  | NO
AV00035 | Ranjitha T | [NAME] | 13000 |  |  | NO
AV00036 | Manjula H S | [NAME] | 13000 |  |  | NO
AV00037 | Bharati Poojari | [NAME] | 13000 |  |  | NO
AV00038 | Bhavani M | [NAME] | 13000 |  |  | NO
AV00039 | Sudha | [NAME] | 13000 |  |  | NO
AV00040 | [NAME] | [NAME] | 13000 |  |  | NO
AV00041 | [NAME] | [NAME] | 13000 |  |  | NO
AV00042 | [NAME] | [NAME] | 13000 |  |  | NO
AV00043 | Munirathna | [NAME] | 13000 |  |  | NO
AV00046 | Nagrathna V Doddamani | [NAME] | 13000 |  |  | NO
AV00047 | [NAME] T | [NAME] | 13000 |  |  | NO
AV00048 | Saritha N | [NAME] | 13000 |  |  | NO
AV00050 | [NAME] A | [NAME] | 9000 |  |  | NO
AV00051 | Girijammanni | [NAME] | 13000 |  |  | NO
AV00125 | Rajeshwari | Angadi SIlks | 12000 |  |  | NO
AV00100 | [NAME] | JW Office | 52000 |  |  | NO
AV00101 | [NAME] | JW Office | 40000 |  |  | NO
AV00102 | Basavaraj N | JW Office | 42000 |  |  | NO
AV00103 | Madesh K M | JW Office | 19000 |  |  | NO
AV00104 | [NAME] Kumar S | JW Office | 11000 |  |  | NO
AV00023 | Shiv Kumar | Driver | 21000 |  |  | YES
AV00024 | [NAME] | Driver | 25000 |  |  | YES
AV00025 | Harish | Driver | 19970 |  |  | YES
AV00026 | Sheshaiah M | Home | 20000 |  |  | NO
AV00027 | Prafulla Das | Home | 17300 |  |  | NO
AV00028 | Punitha | Home | 9000 |  |  | NO
* Whose salary is <=13000, no reduction / days of work