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.