My issue is that I want to have cell E11 equal to cell E8 if cell I8 is an error, but have cell E11 be empty if cell I8 ISN’T an error. I have tried using various combinations of IFERROR and IF functions, but cant come up with a solution. I know basic excel functions but cant figure out some of the more complex ones and when/how to use them. I am trying to make a calculator that outputs all possible answers and stages of simplification of a simple ax^2+bx+c equation, so I am also trying not to mess up my other formulas in the process. Any suggestions? Here is my sheet for reference. Any tips on any of the other parts of the sheep would be great too.

synthetic division calculator.xlsx

​My issue is that I want to have cell E11 equal to cell E8 if cell I8 is an error, but have cell E11 be empty if cell I8 ISN’T an error. I have tried using various combinations of IFERROR and IF functions, but cant come up with a solution. I know basic excel functions but cant figure out some of the more complex ones and when/how to use them. I am trying to make a calculator that outputs all possible answers and stages of simplification of a simple ax^2+bx+c equation, so I am also trying not to mess up my other formulas in the process. Any suggestions? Here is my sheet for reference. Any tips on any of the other parts of the sheep would be great too.synthetic division calculator.xlsx  Read More

​