Right then, any one got an idea how i would right a forumla for this?

Drilling cost: for rock thickness below 5 metres $400,000
from 5 metres to under 9 metres $600,000
from 9 metres to under 11 metres $800,000
from 11 metres to under 14 metres $1,000,000
above 14 metres $1,200,000

Other costs (fixed) $3,000,000

Basically i want in Cell X to get me the drilling cost to what cell Y says the rock thickness is. Then once its worked that out also at the $3,000,000 onto it?

I know its an If formula but do you have to keep putting an If in for every Variable?