Home » Forums » Open Source Learning Center » Question and Answer

Formula require

Submitted by mnca.chirag on 22 February, 2016 - 09:02

I have mentioned requirement in the attached sheet itself. please help as early as possible.

AttachmentSize
Incentive Calculation query.xlsx12.13 KB
‹ Find colour and return the row header Excel Pivot Table / Weighted Averages ›
»

Try this in column W, it will

Submitted by mec1981 on 26 February, 2016 - 01:36.

Try this in column W, it will round the calculationto 2 decimal places

=IF(AND(S5>=100,T5>=100,U5>=100),ROUND((E5*0.02)+(D5*0.01)+((Q5-D5)*0.03)+((R5-E5)*0.03),2),IF(AND(S5<100,S5>60,T5>=100,U5>=100),ROUND((E5*0.01)+(D5*0.01)+((Q5-D5)*0.03)+((R5-E5)*0.03),2),0))

»