Excel formula IF AND OR

Job ID: 33785251

Budget: $10 – $30 AUD

Need someone to make me an excel formula that I can paste into an excel sheet and fill the column and it will return a true of false statement based on multiple conditions. please see logic of forumla in attached word document
Related categories: Data Processing Data Entry Excel Microsoft Office