how to write Formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1380101%22%20slang%3D%22en-US%22%3Ehow%20to%20write%20Formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380101%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20need%20help%20regarding%20excel%20formula%20for%20incremental%20bonus%20value.%3C%2FP%3E%3CP%3EExample%3A%20fix%20bonus%20is%201000%20any%20Qtr%3C%2FP%3E%3CP%3Ex%26nbsp%3B%3C%2FP%3E%3CP%3Eif%201st%20Qtr%20target%20fulfilment%20is%20more%20than%20100%20then%20x%20person%20get%20Rs.3000%2F-in%201st%20Qtr%3C%2FP%3E%3CP%3Eif%201st%20%26amp%3B%202nd%20Qtr%20target%20fulfilment%20is%20more%20than%20100%20then%20x%20person%20get%20extra%20Rs.500%20in%202nd%20Qtr%3C%2FP%3E%3CP%3Eif%201st%2C%202nd%20%26amp%3B%203rd%20Qtr%20Target%20fulfilment%20is%20more%20than%20100%20then%20X%20person%20get%20extra%201000%20in%203rd%20Qtr%3C%2FP%3E%3CP%3Eif%20all%20qtr%20target%20fulfilment%20is%20more%20than%20100%20then%20X%20person%20get%20extra%201500%20in%204th%20Qtr%3C%2FP%3E%3CP%3EBut%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20X%20person%20does%20fulfil%20his%20target%20in%202nd%20Qtr%20then%20he%20gets%20only%20fix%20amount.%3C%2FP%3E%3CP%3Ethen%20start%20from%203rd%20Qtr%20again.%3C%2FP%3E%3CP%3Emeans%20continuously%20x%20person%20meet%20their%20target%20he%20will%20get%20Rs.500%20extra.%3C%2FP%3E%3CP%3Eplease%20Help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1380101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380277%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20write%20Formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380277%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20other%20words%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFixed%20Incentive%20Quarterly%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3BIncremental%20Incentive%20Quarterly%26nbsp%3B%26nbsp%3B%20%26nbsp%3BIncreased%3C%2FP%3E%3CP%3EEarning%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2296%22%3E%3CP%3EQ1%20%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%3CP%3ERs.1000%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22118%22%3E%3CP%3EQ1%20%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%3CP%3ERs.1000%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2288%22%3E%3CP%3ENil%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2296%22%3E%3CP%3EQ2%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%3CP%3ERs.1000%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22118%22%3E%3CP%3EQ2%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%3CP%3ERs.1500%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2288%22%3E%3CP%3ERs.%20500%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2296%22%3E%3CP%3EQ3%26gt%3B%20100%25%20Q4%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%3CP%3ERs.1000%3C%2FP%3E%3CP%3ERs.1000%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22118%22%3E%3CP%3EQ3%26gt%3B%20100%25%20Q4%26gt%3B%20100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%3CP%3ERs.2250%3C%2FP%3E%3CP%3ERs.%203250%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2288%22%3E%3CP%3ERs.%201250%3C%2FP%3E%3CP%3ERs.2250%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380762%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20write%20Formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380762%22%20slang%3D%22en-US%22%3EHi%20Prashant%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20post%20this%20in%20the%20excel%20community%20as%20this%20is%20not%20related%20to%20Microsoft%20Teams.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EMitchell%20Bakker%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

I need help regarding excel formula for incremental bonus value.

Example: fix bonus is 1000 any Qtr

if 1st Qtr target fulfilment is more than 100 then x person get Rs.3000/-in 1st Qtr

if 1st & 2nd Qtr target fulfilment is more than 100 then x person get extra Rs.500 in 2nd Qtr

if 1st, 2nd & 3rd Qtr Target fulfilment is more than 100 then X person get extra 1000 in 3rd Qtr

if all qtr target fulfilment is more than 100 then X person get extra 1500 in 4th Qtr

But 

but X person does fulfil his target in 2nd Qtr then he gets only fix amount.

then start from 3rd Qtr again.

means continuously x person meet their target he will get Rs.500 extra.

please Help

 

2 Replies
Highlighted

in other words

 

Fixed Incentive Quarterly          Incremental Incentive Quarterly    Increased

Earning

Q1 > 100%

Rs.1000

Q1 > 100%

Rs.1000

Nil

Q2> 100%

Rs.1000

Q2> 100%

Rs.1500

Rs. 500

Q3> 100% Q4> 100%

Rs.1000

Rs.1000

Q3> 100% Q4> 100%

Rs.2250

Rs. 3250

Rs. 1250

Rs.2250

 

Thanks in advance

Highlighted
Hi Prashant,

Please post this in the excel community as this is not related to Microsoft Teams.

Kind regards,
Mitchell Bakker