I am struggling to get a conversion of the following Excel formula to work correctly and wondered if someone could offer some advice.

= IF ( G8 = 0 , 0 , IF ( AND ( G8 > 0 , G8 <= 5.3 ) , 12 , IF ( AND ( G8 > 5.3 , G8 <= 9.3 ) , 16 , IF ( AND ( G8 > 9.3 , G8 <= 17.3 ) , 24 , IF ( AND ( G8 > 17.3 , G8 <= 21.5 ) , 32 , IF ( AND ( G8 > 21.5 , G8 <= 33.5 ) , 44 , IF ( AND ( G8 > 33.5 , G8 <= 45.5 ) , 56 , "CANT DO" ) ) ) ) ) ) )

G8 is replaced with my field named B0 = IF ( B0 = 0 , 0 , IF ( AND (B0 > 0 ,B0 <= 5.3 ) , 12 , IF ( AND (B0 > 5.3 ,B0 <= 9.3 ) , 16 , IF ( AND (B0 > 9.3 ,B0 <= 17.3 ) , 24 , IF ( AND (B0 > 17.3 ,B0 <= 21.5 ) , 32 , IF ( AND (B0 > 21.5 ,B0 <= 33.5 ) , 44 , IF ( AND ( G8 > 33.5 , G8 <= 45.5 ) , 56 , "CANT DO" ) ) ) ) ) ) )

So looking at the conditional execution of if, else if, it states to use: if(<if-boolean-expression>)
{
<statements>
}
else if(<elseif-boolean-expression-1>)
{
<statements-1>
}
else if(<elseif-boolean-expression-2>)
{
<statements-2>
}

I can't fathom out how to code if B0 > 0.0 and <5.3, then display 12 or if B0 > 5.3 and <9.3 then display 16, etc else display "Can't Do"

I have been reading through the Control Statements, Configuring Formula Fields, but just can't get it to work.
Any suggestions would be appreciated.