Multiple Condition in one cell

[Asrar Ayub]

Hi All,

I'm having data, if any one of the cell is <35, then in the Total Colum
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 Ayu

+-------------------------------------------------------------------
|Filename: Sample data.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=718
+-------------------------------------------------------------------

 

[Claus Busch]

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

 

[Kevin@Radstock]

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 All,

I'm having data, if any one of the cell is <35, then in the Total Colum
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 Ayu

+-------------------------------------------------------------------
+-------------------------------------------------------------------