case and And Condition Compile Error

[shruthidwh]

Hi,

I need to Include a condition to the below case statement where the cell B value is Bangalore, I tried putting the And Condition but it's giving compile error.


Please help.

Please Login or Register  to view this content.

Regards,
Shruthi

[Fettertiger]

Hi shtuthidwh,

just replace 'Bangalore' by "Bangalore" (with proper quotation marks)

regards

Theo