Excel formula! [Solved/Closed]

Question

Excel formula! [Solved/Closed]

Report

xcel - Apr 29, 2010 at 08:02 AM
xcel - Apr 29, 2010 at 11:49 AM

I would like to make an excel formula that

if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "no".

Excel formula!
@ in excel formula ✓ - Forum - Excel
Excel formula bar missing - How-To - Excel
Excel formula to transfer data between worksheets - How-To - Excel
Excel formula for position ✓ - Forum - Office Software
Excel formula copy rows based on criteria ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-04-29T08:50:54-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Apr 29, 2010 at 08:50 AM

TRY THIS

=IF(COUNTIF(A1:A10,">5")>=7,"ACCEPTED","NO")

Report

xcel
Apr 29, 2010 at 11:49 AM

Thank alo! it works perfect.

Excel formula! [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!