View original (French)

Calculation on R/O exceedance

Astragale -  
ccm81 Posted messages 11033 Status Membre -
Hello,
Could someone help me with a calculation formula please,

Actual sales
Objective
R/O

If R/O >110% and <= 175% then we return the corresponding sales (so only the part > 110%) + 5%

I'm stuck...

Thanks in advance!

1 réponse

Réponse 1 / 1
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

As I understand it
CA in A1
Objective in B1
R/O in C1
D1=IF(AND(C2>110%;C2<=175%);(A2-B2)*1.05;"")

If that's not it, send a complete example

Best regards
0