If statement

**Pjcan1** · 09-14-2015, 03:59 AM

I'm wondering what is the best formulae to use for the situation below

Basically I have six columns, all of which will either have true or false in them. I then want to make an assessment of Pass/Fail based on whether at least 5 of the 6 columns have true in them. Doesn't matter which 5, any less that 5 and i want to Fail

**JohnTopley** · 09-14-2015, 04:08 AM

Try ...

=IF(COUNTIF(A1:F1,"TRUE")>=5,"PASS","FAIL")

**Pjcan1** · 09-14-2015, 04:12 AM

John,

Your a star, works a treat, thanks

If statement

LinkBack

Thread Tools

Rate This Thread

Display

If statement

Re: If statement

Re: If statement

Thread Information

Users Browsing this Thread

Similar Threads

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] If statement to select data - nested statement - assistance

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Bookmarks

Bookmarks

Posting Permissions