Multiple Condition in one cell

A

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
+-------------------------------------------------------------------
 
C

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
Click to expand...

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


Regards
Claus Busch
 
K

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
Click to expand...

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Top