IF with ISTEXT Always True

[Walter45]

Sorry if this has been answered before but I spent a good chunk of this afternoon searching and couldn't figure it out.

I'm trying to have a cell (let's say A1) be blank if there is any sort of text in another cell (B5). B5 has a formula in it that returns some info from another sheet, but I want the cell B1 to show in A1 if B5 is blank. If B5 has its reference, I want to A1 to not return B1. I'm trying to do something like in A1: =if(istext('othersheet!'B5),"", othersheet!'B1). Problem is it always shows the text, I'm assuming because it's got the formula in it.

This issue seems like something I'd have figured out already, but I can't. Can someone please point me in the right direction. I'm assuming it'll be a smh fix, but I appreciate any help!

 

[bebo021999]

Try anyone that works:
A1:
=IF('othersheet!'B5="", "",'othersheet!'B1)
or
=IF(len('othersheet!'B5)>0,'othersheet!'B1,"")

 

[Walter45]

Try anyone that works:
A1:
=IF('othersheet!'B5="", "",'othersheet!'B1)
or
=IF(len('othersheet!'B5)>0,'othersheet!'B1,"")

Totally it. Think yesterday was a long day...

I seriously appreciate your help!