Pls help me with excel formula!

xcel - May 5, 2010 at 04:36 AM
 xcel - May 5, 2010 at 06:39 AM
Dear excel experts,

I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 then report me as "up regulated".
And If at least 10 cell of A1:A15" are less than 0.5, then report me as "down regulated".
Otherwise "no change".
In that situation, can i write excel formula like this?

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

FYI, it gives me error :-(

Thank alot in advance!

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
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"))
great job! it works fine now.. thank a million !!!!!!!!!!