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!
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!