Help with IF, Nested IF and Vlookup! I dont know where to start

i have a certain reimbursement rate for certain zip codes. There are 2 levels, rural and super rural. Each has its own rate of reimbursement. For instance, Rural is 284.75, while super rural is 349.10-for one particular service (A0426)


Part of the problem is that there are different services. (A0426, A0427, A0428, A0429, A0433 and A0434). Each pays a different rate.
There is also mileage which is paid per mile (A0425).


We want to type in a zip code, service and mileage and have a formula that figures out how much to bill. Where do i start??? thanks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok, i have most of it done, with the help of a friend. I have one more problem though.
I have cell M7 set up to return a value (Rural, Urban or Super Rural) based on zip code.
Each indiciator (R, U, SR) has a different cost. I need to use IF (i think) to assign each indicator the appropriate value. For instnace, Rural = $1 , Urban = $2, Super Rural = $3.
Any advice? i cant seem to get it working.
Thanks

Something like ..???

=IF(M7="R",1,If(M7="U",2,3))

ah, so the false value would be 3. that makes sense. I was trying to put 3 If statements in, but i only need 2 and 3rd would be the false value.
thanks so much!

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.