TomSalvato
Technical User
Good afternoon, Experts.
I'm need a formula to calculate COL-C.
If both A and B have data, then I need the result (in COL-C) to show both fields separated by a / character.
If only one of A or B have data, then I need the result (in COL-C) to show just the one field (no / character).
I'm very rusty with these excel if formulas so I'm hoping one of you guys could help me out.
Thanx in advance!
Example - desired results
COL-A COL-B COL-C
3333 3333
2222 3333 2222/3333
9999 9999