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.
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
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