Combining cells

[Lord Ralin]

Hi, I'm new to excel and am having problems figuring this formula out. Ok, so I would like to write a formula that if on sheet2 I have text in one cell, call it A3, on sheet1 it will display the value of the next two cells, B3 & C3, on sheet1 looking like this, B3 / C3. However if there is not a number in C3 I would like to just display the value in B3 on sheet1 without the /. This is what I came up with but it displays the value like this B3/. =IF(ISTEXT('sheet2'!A5),IF('sheet2'!I5>0,'sheet2'!H5&"/"&'sheet2'!I5,""),"").

[sktneer]

Maybe this.....

=IF(ISTEXT(Sheet2!A5),IF(Sheet2!I5>0,Sheet2!H5&"/"&Sheet2!I5,Sheet2!H5),"")

Does this help?

[Lord Ralin]

Thanks for the quick response. However this is one version of the formula that I have tried and it continues to give back H5/.

[mjwiegant]

Hi Lord Ralin,
You might try this formula: =IF(ISTEXT('sheet2'!A3),IF('sheet2'!B3>0,'sheet2'!B3&IF(C3<>"";"/";"")&'sheet2'!C3,""),"")
I have translated it from Dutch to English, so I hope I did it right ;-)
Best regards,
Maarten

[Lord Ralin]

Thanks for the quick response. I tried this formula and I keep getting an error box. I've been playing around with this formula and I haven't been able to get it to work.

[Lord Ralin]

Sorry my first response was for sktneer and the second for mjwiegant.

[Lord Ralin]

@mjwiegant, Success. I finally got it to work. Thank you so much I was getting a little frustrated.