Hi All,

I am unable to write a formula for the below problem

If Cell A is "Si" and Cell B is "A00", cell C should return value 100
If Cell A is "Si" and Cell B is not equal to A00, cell C should return a value 200
If Cell A is "Me" and Cell B is "A00", cell C should return value 300
If Cell A is "Me" and Cell B is not equal to A00, cell C should return a value 400
If cell A is "Co" and Cell B is "A00", cell C should return value 500
If Cell A is "Co" and Cell B is not equal to A00, cell C should return a value 500

Kindly suggest solutions

Thanks in Advance

Vishwa