Hey team,

I'm trying to create an IF statement with the following conditions but am not sure how to get it working.

IF G22 is 5.99 or less then multiply(G13) by 0
If G22 is 6 to 6.99 then multiply(G13) by 10
If G22 is 7 to 8.99 then multiply(G13) by 25
If G22 is 9 to 9.99 then multiply(G13) by 30
If G22 is 10 or more then multiply(G13) by 40

But the below I tried didn't work.

=IF(G22, < 6, G13*0, IF(G22, < 7 > 6, G13*10, IF(G22, < 9 > 7, G13*25, IF(G22, < 10 > 9, G13*30, IF(G22, =>10, G13*40)))))