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

Hi Asrar Ayub

If your data is in A1:G4, in G2 and copy down:

=IF(MIN(B2:F2)<35,"Fail",SUM(B2:F2))

Hi,

Am Thu, 27 Dec 2012 07:15:05 +0000 schrieb Asrar Ayub:

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

try:
=IF(MIN(B2:F2)<35,"FAIL",SUM(B2:F2))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2