Hi,
Check this link: Multiple conditions on Salary Structure with a single formula - #13 by ben
Hope this helps.