Forum Discussion

KalebLedonne's avatar
KalebLedonne
Copper Contributor
May 05, 2020
Solved

Table Equations

This is probably pretty easy... however I cannot figure it out. I have a table filled with data, and some rows are calculating proportions compared to other rows:   I have many blank rows ins...
excel
Formulas and Functions
  • macrordinary's avatar
    macrordinary
    May 05, 2020

    KalebLedonne In this case, use an IFERROR formula to suppress rows where there is no value instead of just dividing the values.

     

    =IFERROR([@[Sorter Stop Count]]/[@[Gross Inducts]],"")

macrordinary's avatar
macrordinary
Brass Contributor
May 05, 2020

KalebLedonne In this case, use an IFERROR formula to suppress rows where there is no value instead of just dividing the values.

 

=IFERROR([@[Sorter Stop Count]]/[@[Gross Inducts]],"")

Resources