Excel formula!

Solved/Closed

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!
1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
Excel date format dd.mm.yyyy - Guide
Number to words in excel formula - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to ignore false in excel formula ✓ - Office Software Forum

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 29, 2010 at 08:50 AM

TRY THIS

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

xcel
Apr 29, 2010 at 11:49 AM

Thank alo! it works perfect.

Subscribe To Our Newsletter!