Forrmular for WBC white blood cell counting two column numbers

[sakijung]

I have a problem about my wbc counting. A1 3000 b2 5000 c1 2500 d1 show Lower if less than a1 Greater if higher than b2 and normal for between 3000-5000 by using number to check standard between a1-b2. Thanks you.

 

[Joe4]

Is this what you are looking for?

<a1,"lower",if(c1>=IF(C1 < A1,"LOWER",IF(C1 > B1,"HIGHER","NORMAL"))

</a1,"lower",if(c1>

 

[sakijung]

Before I follow the link to see the answer I think why I do not use like score grading. And I search in this board is about 0-1000 Euro get -10% like that and they use array formula. Make me confuse. Thanks for quick answering.