Formula Assistance

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

Good morning. I have a spreadsheet that I need assistance
with a formula. I have two cells - each with formulas in
them. Only one of these cells will be populated with
an "answer", the other cell will display "DIV/0! (formula
error). Basically I need help writing a formula that
says, look at the two cells, the one that has
the "answer", copy the answer to this cell.

Here is my example:

Cell A3 - 3.49 (A number is what is returned via a
formula in the cell, it could be positive or negative)

Cell B15 - DIV/0! (Data entered did not return an outcome)

Cell C25 - I need the formula to say, look at A3 & B15,
the cell that retuns the number, copy the outcome it to
cell C25.

HELP!! If someone can assist it would be greatly
appreciated. Please post questions if more info is
needed.

Thank you in advance for your assistance.
 
Hi
better would be to prevent this #DIV/0 error. You may
change the formula to something like
=IF(N(cell_ref1)=0,"",cell_ref2/cell_ref1)


but if you this kind of error try
=IF(ISERROR(A3),IF(ISERROR(B15),"no answer",B15),A3)
 
Back
Top