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 inserted at the bottom of the table for future data entries, however these equations are giving me the divide-by-0 error as there's no data entered yet, obviously. How do I make it so that I can enter new data with the proportions automatically being calculated, but not showing the error while that row is still empty?

 

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]],"")

1 Reply

  • 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