conditional formula

I want the result in column C as "Non Qualifying Asset" else blank to be displayed if the household in A column is rural column M>60000 & or urban column M>120000.

Regards,
Jagadish

Thanks dillip
Jagadish

Originally Posted by dilipandey

Hi Jagadish,

See the attached file.
Let me know if this is want you are looking forward


Regards,
DILIPandey

< click on below 'Star' if this helps >