# Pls help me with excel formula!

Solved/Closed
Related:

- Pls help me with 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
- Excel free download - Download - Spreadsheets

## 1 response

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

May 5, 2010 at 06:12 AM

May 5, 2010 at 06:12 AM

you are close. I am presuming this part is error "AG2:AT2" and you meant A1:A15

=IF(COUNTIF(A1:A15,">=2")>=10,"up regulated", IF(COUNTIF(A1:A15,"<=0.5")>=10,"down regulated", "no change"))

=IF(COUNTIF(A1:A15,">=2")>=10,"up regulated", IF(COUNTIF(A1:A15,"<=0.5")>=10,"down regulated", "no change"))

May 5, 2010 at 06:39 AM