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.
2 Replies
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)
- Hello,
Assume you have the following values: 0 in cell A1 and 25 in cell B1
Execute the formula: IF(A1=0, B1, 0)
What the above means is that if the value in cell A1 equal 0 ( which is true), return the value in cell B1 which is 25. If false, return 0
I hope this help
