Excel Forum

IF formula

Hemanshu Mehta

New Member

Members

Forum Posts: 1

Member Since:
June 20, 2022

Offline

June 20, 2022 - 5:18 am

Dear Experts,

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.

-Hemanshu

				Total
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

See Answer

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 607

Member Since:
January 31, 2022

Offline

June 20, 2022 - 2:43 pm

I assume that the number 200 in C4 of the file you attached should in fact be 250, in order to be consistent with the other ranks. If that is correct, then the formula in E2 could be:

=(200+(B2-1)*50)*A2

and copy it down.