Help with if/or formula - attachment

[iimmie]

2XX VJ VENDOR PAYROLL (0X-XX to 0X-XX) TEST.xlsx

Trying to write the following, Any help would be appreciated, Thanks!

SUM OF (QUEENS I1120)
IF CELL (SUMMARY) B9 IS BETWEEN 0-300 MULTIPLY B9 BY SUM OF UNIT COUNT BY $2.00 (OTHERWISE ENTER ZERO)
IF CELL (SUMMARY) B10 IS BETWEEN 301-399 MULTIPLY B10 BY SUM OF UNIT COUNT BY $2.50 (OTHERWISE ENTER ZERO)
IF CELL (SUMMARY) B11 IS GREATER THEN 400 MULTIPLY B11 BY SUM OF UNIT COUNT BY $3.00 (OTHERWISE ENTER ZERO)

[Speshul]

Try this instead of an IF statement

Place in E9:
=IFERROR(B9*LOOKUP(B9,{0,301,400},{2,2.5,3}),0)

And copy down

[iimmie]

2XX VJ VENDOR PAYROLL (0X-XX to 0X-XX) TEST.xlsx

I made an error in my original upload. This formula did not work. I revised and attached again, showing what the new formula should be and what the totals should look like,
My apologies.

[iimmie]

Revised

I made an error in my original upload. This formula did not work. I revised and attached again, showing what the new formula should be and what the totals should look like,
My apologies.

[dingdongsilver]

Is this what you were looking for? This is a quick and dirty. It's extensible after the first row. I recommend a column like I made for unit tier so you can easily change things later.