I need an Excel formula

Job ID: 35253368

Budget: $10 – $30 AUD

I need an Excel formula for the situation shown in the provided file.
Related categories: Excel Excel VBA