Is it possible to join two nested IF/ AND statements? I would like to join the following in cell I8 so if the first statements are false then the second would be evaluated:
IF(AND($G8>0,$G8<3.01),0,IF(AND($G8>=3.01,$G8<5.01),11,IF(AND($G8>5,$G8<101),$G8*3.2,IF(AND($G8>100.99,$G8<501),$G8*2.1,IF(AND($G8>500.99,$G8<1001),$G8*2,IF($G8>1000.99,$G8*1.9))))))
IF(AND($H8>0,$H8<501),$H8*2.5,IF(AND($H8>500,$H8<1001),$H8*2,IF($H8>1000,$H8*2.9)))
Many thanks!
Add new comment