Previous Topic Next Topic

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
Related: