Trying to add formula to excel that will return different results based on price

I'm wondering if there is an automatic formula that will return different results based on price. ie < than $10 add 40%, < than $20 (or $11 to $20) add 1.25 and so on instead of me manually doing each cell. Also is there a way to hide formulas other than protecting the sheet. Any help would be appreciated