1. 'IF WITH AND' - USE IF FORMULA AS PER CONDITION
Find the category as per given condition in the data using IF Formula.
Example:
=IF(AND(H5>=70,H5<=100),"A",IF(AND(H5>=50,H5<70),"B",IF(AND(H5>=25,H5<50),"C",IF(AND(H5<50),"D"))))
Popular Post
-
1. LEN The LEN function is usually for count the values length from your selected range. Example: = LEN(text) = LEN( D2 ) 2. LET
No comments:
Post a Comment