ExcelBanter - Multiple Condition in one cell

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Multiple Condition in one cell (https://www.excelbanter.com/new-users-excel/447903-multiple-condition-one-cell.html)

Asrar Ayub

Multiple Condition in one cell

1 Attachment(s)

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

Claus Busch

Multiple Condition in one cell

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

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))

Quote:

Originally Posted by Asrar Ayub (Post 1608269)

All times are GMT +1. The time now is 07:03 AM.