If condition to calculate incentives slabs

Closed
sonu_vjti Posts 1 Registration date Thursday January 9, 2014 Status Member Last seen January 9, 2014 - Jan 9, 2014 at 05:44 AM
IF(E162>=50,IF(F162>=50000,IF(F162<74999,"Slab1",IF(E162>=75,IF(F162>=75000,IF(F162<99999,"slab2"))))))
there are two cell in one there is units and other is value condition should match the both to calculate the incentives to put in slab
wants to continue the slab till 9 but not happening is there any other condition that continues the slab till 600000