Forum Discussion

MAIFG3's avatar
MAIFG3
Copper Contributor
May 26, 2021
Solved

No funciona una fórmula

Buenos días.  En la columna C tengo una fórmula para calcular un promedio sobre las celdas donde hay números. Como en esas celdas tengo puesta una fórmula, no me calcula el promedio. Cuando le quito...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 27, 2021

    MAIFG3 

    Thank you! The problem is caused by the formulas in columns E:F, I:K and M:O.

    For example in E7:

     

    =SI.ERROR(SI(D7="MB";"10";SI(D7="B";"7,5";SI(D7="R";"5";SI(D7="M";"2,5";" "))));"")

     

    The return values "10", "7,5" etc. are text because of the " ", not numbers! PROMEDIO ignores text values. It should be

     

    =SI.ERROR(SI(D7="MB";10;SI(D7="B";7,5;SI(D7="R";5;SI(D7="M";2,5;""))));"")

     

    See the attached version.

MAIFG3's avatar
MAIFG3
Copper Contributor
May 26, 2021

HansVogelaar 

En la columna C tengo una fórmula de promedio. En la otras tres tengo una fórmula de =SI(, respecto a la columna D.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 26, 2021

    MAIFG3 

    OK, but what is the formula in column C?

    • MAIFG3's avatar
      MAIFG3
      Copper Contributor
      May 26, 2021
      =SI.ERROR(PROMEDIO(SUMA(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7));"-")
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 26, 2021

        MAIFG3 

        SUMA(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7) returns a single value. There is no point in using PROMEDIO on a single number.

        Does this do what you want?

         

        =SI.ERROR(PROMEDIO(E7:G7;I7:K7;M7:O7;Q7:S7;U7:W7;Y7:AA7;AC7:AE7;AG7:AI7);"-")