Hi All,

I'm having data, if any one of the cell is <35, then in the Total Column it should be display as "FAIL", as shown below.

Which condition (Formula) do i need to use?

Name M-1 M-2 M-3 M-4 M-5 Total
Ram 55 66 77 88 55 340
Shankar 77 88 99 10 66 FAIL
Matthew 88 77 88 66 77 396



Let me know the resolution..

Regards,
Asrar Ayub