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
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
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.
Sorry my first response was for sktneer and the second for mjwiegant.
@mjwiegant, Success. I finally got it to work. Thank you so much I was getting a little frustrated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks