Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL-formula help 2

Status
Not open for further replies.

TomSalvato

Technical User
Mar 24, 2010
64
US

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
 
Hi,

Your desired results, I'm guessing...
[pre]
COL-A COL-B COL-C
2222 2222
2222 3333 2222/3333
4444 4444
[/pre]

Formula
C2:=A2&IF(ISBLANK(B2),"","/"&B2)

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
 
Your 'Example - desired results' are wrong :-(

Try this formula in cell C2: [tt]=IF(OR(ISBLANK(A2), ISBLANK(B2)), A2 & B2,A2 &"/" & B2)[/tt]


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
TomSalvato said:
If only one of A [red]or[/red] B have data...

So, this is also a possibility:

[pre]
COL-A COL_B COL_C
2222
2222 3333
4444
5555
[/pre]


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
Combo - never even heard of that formula. Does exactly what I needed. Thanks again, sir.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top