If condition to calculate incentives slabs

[Closed]
Report
Posts
1
Registration date
Thursday January 9, 2014
Status
Member
Last seen
January 9, 2014
-
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