Pls help me with excel formula!
Solved/Closed
Related:
- Pls help me with excel formula!
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
5 May 2010 à 06:12
5 May 2010 à 06:12
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"))
5 May 2010 à 06:39