Forum Discussion
Excel Formula
Hi, I need some help to create a formula for this request. - If the cell value is 0 (zero) I need to take the value from another cell.
If value in the cell is entered manually, you can't check it and return another value into the same cell by formula, that's only with VBA programming.
If in the cell is calculated result, you may adjust calculation formulas.
If you'd like to check the value in the cell, compare with zero and put zero or another cell value into third cell, that simple IF(), or like =B1*(A1=0)