Uncategorized

Multiple range

=IF(D4=”Centre In charge”,800,IF(D4=”Question Collector”,500,IF(D4=”Hall Super”,600,IF(D4=”Assistant Hall Super”,500,IF(D4=”Invigilator”,300,IF(D4=”Secretary”,500,IF(D4=”Office Assistant”,300,IF(D4=”PA to Principal”,300,IF(D4=”Special Officer”,300,IF(D4=”Accounts Officer”,150,IF(D4=”Department MLSS”,50,IF(D4=”Office MLSS”,70,IF(D4=”Driver”,150,IF(D4=”Technician”,100,IF(D4=”Computer Operator”,100)))))))))))))))

Leave a Reply