Forum Discussion

Umeshmaini's avatar
Umeshmaini
Copper Contributor
May 30, 2022

Need formula for following

producttgtsalesbonus abonus bbonus c  
        
a10201.51.752.5  
b10201.51.752.5  
c10201.51.752.5  
d10201.51.752.5  
        
        
Need a formula for above to calculate bonus, condition is if c5>=b5 bonus will be c5*1.5
Second condition if c5>=b5 and (c6>=b6 and c7>=b7) then c5*1.75
third condition if c5>=b5 and (c6>=b6, c7>=b7 and c8>=b8) then bonus is b5*2.5

 

Please help, thanks in advance

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Your last bonus outcome seems to be different than Bonus A and B. I'm presuming you meant to say C5*2.5.

    This might work:
    =CHOOSE(SUM(IF(C5:C8>B5:B8,1,0)),C5*1.5,0,C5*1.75,C5*2.5)
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Umeshmaini 

    Here is probably a mistake in reasoning or I do not understand from the previous text what exactly is to be achieved :).
    Please specify where is C5, C6, etc..
    I can't tell what's where from the text.

    My time is too valuable for guessing...for me :).

     

    In addition, if I may recommend, attach a file (without sensitive data) or a photo and use this to describe exactly what you intend to do. Knowing the Excel version, operating system, storage medium could possibly help again.

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources