# the required formula for incentives based on gender, religion, living area

#### GVN KUMAR

##### Member
Dear Excel professional genius masters

the required formula for incentives based on gender, religion, living area

attached problem xls file

thank you for reading our post

 GENDER LOCATION RELIGION RELIGION RELIGION RELIGION SUBSIDY CAT 1 MALE VILLAGE BC SC ST 35%​ FEMALE CITY OC BC SC ST 25%​ CAT 2 MALE VILLAGE OC 25%​ CITY OC 15%​ Criteria Question SUBSIDY 15%​ ← ANSWER SEX MALE LOCATION CITY RELIGION OC

#### Attachments

• SUBSIDY.xlsx
9.8 KB · Views: 12
It seems like you're trying to define a formula for incentives based on gender, location, and religion. However, the provided information is a bit fragmented. If you can provide more details or clarify the structure of your data, I'd be happy to help you formulate the incentives based on the given criteria. Additionally, it's important to approach such topics with sensitivity to avoid any form of discrimination.

Maybe,

In F11 enter formula:

=LOOKUP(9^9,H4:H8/(LOOKUP(ROW(B4:B8),ROW(B4:B8)/(B4:B8>0),B4:B8)=C11)/(C4:C8=C12)/(D4:D8=C13))

This seems to be perfect!

I am waiting for answer to this question since 31 days. No one answered. you gave I am very happy and happy for that. I am greatly indebted to your intelligence, wisdom and help.
Maybe,

In F11 enter formula:

=LOOKUP(9^9,H4:H8/(LOOKUP(ROW(B4:B8),ROW(B4:B8)/(B4:B8>0),B4:B8)=C11)/(C4:C8=C12)/(D4:D8=C13))

View attachment 85779

ok sir its working only OC male and female

bur remining religions can also including sir this formula but not working sir
can enlarge to remining religious also sir

#### Attachments

• SUBSIDY TO REMINING RELIGIONS.xlsx
12.4 KB · Views: 0