Excel Question IF a cell is?

Question

Have a quick excel question.

I need the formula for the following scenario

If Cell A is equal to 0 then grab cell B, But If Cell A is not equal to 0 then grab Cell A


I've tried the following when the A1 has a number that is not 0.. it grabs A1

IF(A1=0,B1,A1)


But when A1 is 0 it still grabs A instead of grabbing B

Answer 1

Look at the contents of B1. It may be empty or it may be linked to A1 or some cell that produces the same value as A1. If it is empty, the rules of Excel may force a value of 0. I tried it in Libre (open source) and it worked the way you want but I used the 'function wizard' to create the formula and it put an = sign before the if. That may be important.

Answer 2

there isn't any basic thank you to to reference an excel record from yet another one. try a sort of ideas: * while working on your record, have the information record open in the historical past * in basic terms reproduction the information, if it rather is not changing * set the information record as a "ODBC archives resource" on your notebook. this way you could refresh the sum formula each and every time you open the record and on request. toughest to do, even with the undeniable fact that that's a thank you to do it.

Answer 3

Your formula is correct. Perhaps you have the letter "O" instead of a zero.

.

Answer 4

This formula has Circular referance. Hence it may cause problem. The referance in invalid in few cases. Please modify it.