June 20, 2022
I have total nine ranks (i.e. 1 to 9), each rank has different number of students and allowance is based on rank for each student. I need formula in column D to match the conditions. I know "IF" formula will work but how?? I don’t know. Below is descriptive example. Attached excel file has few rows only but actually with the given conditions, I have 100s of rows.
Thanks in advance.
|If Rank is 1, No of Studnets are 3, allowance per student is 200||600|
|If Rank is 1, No of Studnet 1, allowance per student is 200||200|
|If Rank is 6, No of Studnet 2, allowance per student is 450||900|
January 31, 2022