IF function for multiple FILTERS

Hi All, I have a requirement to create a new column for the below-given table: Thank you in advance order No Cust Name Y/N? Revenue class Amount New column 111 ABC Y Apple 100 Flex ...