Hi Asrar Ayub
If your data is in A1:G4, in G2 and copy down:
=IF(MIN(B2:F2)<35,"Fail",SUM(B2:F2))
Quote:
Originally Posted by Asrar Ayub
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
|