View original (French)

Calculation on R/O exceedance

Astragale -  
ccm81 Posted messages 11033 Status Member -
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 answer

  1.
    ccm81 Posted messages 11033 Status Member 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