Pls help me with excel formula!
Solved/Closed
Related:
- Pls help me with excel formula!
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to ignore false in excel formula ✓ - Forum - Office Software
- Number to words in excel formula - Guide
- Excel formula to transfer data between worksheets - Guide
1 reply
rizvisa1
May 5, 2010 at 06:12 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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