Oct 15 2020 07:41 PM
The IF Formula in the attached spreadsheet doesn't recognize "#N/A"
Oct 16 2020 12:51 AM
Oct 19 2020 04:49 AM
I tried using the IFERROR formula but there is still a problem. Column B returns a number. Sometimes that number is an error. Whenever it returns an error I want to use the previous number it returned (same column, previous row). So I wrote the following formula in the adjacent column: =IFERROR(B8,B7). But it doesn't seem to work.
I attached the file below.
Oct 20 2020 03:39 AM - edited Oct 20 2020 03:57 AM
Solution@Sam_S007 if I understand what you're wanting to do then change the formula in C8 from this ...
=IFERROR(B8,B7)
... to this ...
=IFERROR(B8,C7)
... and fill all the way down. Does that now do what you want?
Oct 20 2020 03:39 AM - edited Oct 20 2020 03:57 AM
Solution@Sam_S007 if I understand what you're wanting to do then change the formula in C8 from this ...
=IFERROR(B8,B7)
... to this ...
=IFERROR(B8,C7)
... and fill all the way down. Does that now do what you want?