I am rather new to spreadsheets, and I feel like what I want to accomplish is rather simple, but I am having enormous difficulty finding anyone else doing something similar.
I have values in column A and B, and I want to divide
B3, etc. and output to column C. Putting this in
C2 DOES work:
But the rest of column C all the way down displays
#DIV/0!. A little research uncovered the
IFERROR function. Perfect! So I tried:
But this does not change the output. Still
#DIV/0! all the way home. Am I using
IFERROR wrong? Is there a way to select on the cells that have values? Is there another solution?