Forum Discussion
Solved
Excel formula
Hello formula friends, I have a column (let's say column B) that I would like to create a formula for. The gist is: - if column A has a value, then column B should be empty. - if column A doe...
Hi LauraJackson This formula should works=IF(A2<>"";"";B2).
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c
Hi Leo,
Option 1 is perfect! I had not thought about it that way. Any thoughts on how I could create this formula in a column C?
- if column A has a value, then column C should be empty.
- if column A does NOT have a value, then column C should populate from column B.
Hi LauraJackson This formula should works=IF(A2<>"";"";B2).
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c
- That worked perfectly. Thank you very much Leo!