Sam_S007Copper ContributorOct 16, 2020SolvedExcel IF Formula The IF Formula in the attached spreadsheet doesn't recognize "#N/A" IF FORMULA.xlsx36 KBBradD to Sam_S007Oct 20, 2020Sam_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?
BradD to Sam_S007Oct 20, 2020Sam_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?
BradD to Sam_S007Oct 20, 2020Sam_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?
BradDBrass ContributorOct 20, 2020Sam_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?