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 apk for pc - 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