Pls help me with excel formula! [Solved/Closed]

Report
-
 xcel -
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
766
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 !!!!!!!!!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!