Forum Discussion

deniztopcu's avatar
deniztopcu
Brass Contributor
Sep 12, 2023
Solved

Is there a solution to using the same function multiple times?

Hello, is there a shorter way to do such repetitive calculations? ı havent office 365.
Formulas and Functions
deniztopcu's avatar
deniztopcu
Brass Contributor
Sep 13, 2023

mtarler 

I should compare the price change in the relevant period with each growth percentage and if it increased by more than the growth percentage I should get -1 (for each rate) point, if it increased less than the growth percentage I should get +1 (for each rate) point. This is the logic. 

In its simplest form, it checks > and < for each growth percentage.

 

(TOPLA.ÇARPIM((B9<K9:AL9)*(($K$8:$AL$8="QoQ")+($K$8:$AL$8="QoQ TTM"))*(K9:AL9<>""))-TOPLA.ÇARPIM((B9>K9:AL9)*(($K$8:$AL$8="QoQ")+($K$8:$AL$8="QoQ TTM"))*(K9:AL9<>""))+
TOPLA.ÇARPIM((C9<K9:AL9)*(($K$8:$AL$8="YoY")+($K$8:$AL$8="YoY TTM"))*(K9:AL9<>""))-TOPLA.ÇARPIM((C9>K9:AL9)*(($K$8:$AL$8="YoY")+($K$8:$AL$8="YoY TTM"))*(K9:AL9<>""))

 

  

I then want to do an additional +/- point check to check how much the price is above/below the growth percentage.
And as you said, here is the real problem. Things get complicated when negative numbers are involved.

 

 

 

mtarler's avatar
mtarler
Silver Contributor
Sep 13, 2023
this 'analysis' is still a mystery to me. I think you are trying to give 'points' for being above or below threshold and 1pt for just above/below and 2pts for a bit more and so on for a max of 5pts being really far extreme and then taking the difference between the above and below. but please correct or clarify if you could.
that all said the whole -.9 or -.1 products are still concerning as I don't know they are doing what you think. remember multiplying by -1 on each side of an inequality reverses the inequality to consider if -B9>K9:AL9*{-1, +0.1, +0.2 ....} makes sense to what you want.
  • deniztopcu's avatar
    deniztopcu
    Brass Contributor
    Sep 14, 2023

    mtarler 
    Restructuring is what I want to do. I hope I can explain what I want to do this time. with 3 different ways

    I made the calculations only with the "QoQ and QoQ TTM" headings.
    If everything is correct, I will need to add the "YoY and YoY TTM" headers to the calculation.

     

Resources