mercredi 13 février 2019

If-else statement with multiple conditions in microsoft excel

Is there a formula in Microsoft Excel 2007 wherein I can have multiple "else" statement if a specific keyword is found in the cell that I'm calling. For example, if cell C3 contains the word "Network" it will automatically input "5" in cell B3, otherwise if it contains the word "Software", it will input "4" in cell B3 and so on. I've tried using this code below but it shows error

=IF(OR(SEARCH("Har",C5)),"6", IF(SEARCH("Soft", C5)), "7","")

Aucun commentaire:

Enregistrer un commentaire