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

[GVN KUMAR]

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

 

[Monty]

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.

 

[bosco_yip]

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))

 

[Monty]

This seems to be perfect!

 

[GVN KUMAR]

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

 

[GVN KUMAR]

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

 

[bosco_yip]

please open a new thread for your new question.