Nov 16 2019 07:16 AM
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.
Nov 16 2019 07:22 AM - edited Nov 16 2019 07:25 AM
Nov 16 2019 12:01 PM
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)