In column K, I have some data categorized by 3 different values : Rent, Stacked, Available
What I am attempting to do is put together a formula that will get me a count of each of these, and then figuring out if they are less than, or greater than a number that we will set as the "threshold". I think there's something with the nested IF statements that aren't allowing it to work.
Reading it out the formula should go like this - if the count of "rent" is greater than 30, than it is outside of threshold, otherwise if the count of "stacked" is greater than 30, than it is outside of threshold, otherwise if the count of "available" is greater than 40, than it is outside of threshold, but if none of these are outside of the threshold, than they are within threshold.
Currently what i have is this: =IF(COUNTIF($K:$K,"Rent")>30,"Outside Thresh",IF(COUNTIF($K:$K,"Stacked")>30,"Outside Thresh",IF(COUNTIF($K:$K,"Availble")>40,"Outside Thresh","Within Thresh")))
This seems simple enough, but I don't know if I've overthought it so much that now I can't figure it out.
Any assistance will be appreciated.
Aucun commentaire:
Enregistrer un commentaire