Wanting to string multiple IF(AND) statements together

I'm brand new on this forum, but an oldie to excel. However I'm completely stumped on this one.

I have attached the spreadsheet. I have the following formula which is working just fine.

=IF(AND(A12="Burnaby",C12="Diesel"),0.03046,0.03625)

But I'd like to string together another IF(And) statement together as I have 3 conditions to be met rather than two.

Background to the data:
These are hauling rates. There are 3 conditions that determine price:
1. The city it was picked up in (there are only two choices - which I think is important to note as maybe it can be simplified to a true false condition)
2. The city where it is going (this is where it's tricky because there are 5 variables)
3. If it is gas or diesel (Again there are only two choices - again the true false can maybe work)

The above formula works if it is going to Penticton from Burnaby and decides the rate based upon gas or Diesel. How do I make it look at all of the variables? should I be throwing an "If(Or)" in there too, everything I've tried errors out on me...

Or should this be done in VBA? In which case I will also need help - but that's a different forum - I will post the same question over there if we can't figure this out here

The spreadsheet shows my starter formula, and there is a tab showing the rates (maybe I need to refer back to it in my formula?)

Any help/tips/tricks would be lovely!

Suzy