Multiple if conditions

[selvamnarayanan]

Sir

Can you help me

I have 7 columns In Excel (Rows A to G) with 100 rows of data
Column F is used for Departments. Total 18 depts in Excel

How do I write a function or macro in excel to to group the depts as follows:
Dept A,B,C=Good, Dept D, K, N=Average, Dept M=Review & so on
This Grouping must appear in Column H

Thank you
selvam narayanan

 

[Joe4]

One easy way would be to create a lookup table with two columns with all 18 departments and their corresponding values. The first column is the department code. The second is your value (Good, Average, Review, etc).
Then, simply use a VLOOKUP formula in column H to lookup the department from column G and return your desired value.
See: https://www.techonthenet.com/excel/formulas/vlookup.php