Help with IF formula?

[socals]

Hello All, I am trying to figure out a formula that will calculate if there's a number in an adjacent cell and if not, display nothing but I don't think I'm searching for the right thing because I can't seem to find what I need.

In cell A1, I have a number that displays inches. In cell B1, I have a formula that converts it to feet and inches (=INT(A1/12)&"' "&MOD(A1,12)&""""). What happens is it shows 0'0" when there isn't data but I would rather it be blank. My Google searches led me to IF statements but I haven't seen anything that shows what I'm looking for so I may be looking at the wrong thing.

Thank you in advance for your help.

 

[Joe4]

Try this:

=IF(A1="","",INT(A1/12)&"' "&MOD(A1,12)&""""))

What it essentially says is if A1 is nothing, return nothing. Otherwise, return your calculation.

 

[Fluff]

How about

=IF(A1="","",INT(A1/12)&"' "&MOD(A1,12)&"""")

 

[socals]

Thank you. I really appreciate your time!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

You are welcome.
Glad we could help!