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

If condition to calculate incentives slabs
How to calculate position in excel ✓ - Office Software Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
How to calculate vat in excel - Guide
If cell contains text then return value multiple conditions ✓ - Excel Forum
How to calculate percentage to paisa - Office Software Forum

Subscribe To Our Newsletter!