Excel formula! [Solved/Closed]

Report
-
 xcel -
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".

1 reply

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


=IF(COUNTIF(A1:A10,">5")>=7,"ACCEPTED","NO")
Thank alo! it works perfect.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!