# Formula to return a unique Rate basis n number of conditions.

• Hi All,

I am trying to build a formula that returns a monthly rate basis a couple of criteria.

I tried using nested if's but something's going wrong.

I have attached my spreadsheet for reference. The rate card to the right of the sheet is the basis for my calculation. The logic is: A certain Role against a certain location should return a unique rate.

For example if I select the role as developer from the Validation and Onshore as location from its validation then formula should return the rate as \$20.00.

## Files

• Re: Formula to return a unique Rate basis n number of conditions.

=indirect("r" & match(b2,l:l,0) & "c" & match(c2,10:10,0),0)

• Re: Formula to return a unique Rate basis n number of conditions.

Another way:

=INDEX(\$M\$11:\$N\$14,MATCH(B2,\$L\$11:\$L\$14,0),MATCH(C2,M\$10:N\$10,0))

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!