Connecting IF Statements

I’ve spent considerable time trying to create an IF statement that represents the following:

if b40 = 1 and b54 =less than 100 then b31, greater than 100 but less than= 200 then b32, greater than 200 but less than 300 then b33, greater than 300 but less than 400 then b34, else 0

Here is what I have so far. The statement to the left of the : works. I can’t seem to get the next piece to work.
=IF(B43=1,B54<=100)*B31:IF(B43=1,B54>100<=200)*B32 Thank you in advance for your assistance. Regards Larry