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).
Im using Excel 2007
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