Blank cell concept

[nedrockextreme]

Hi wonder if anyone had any ideas that could help.

I'm trying to work out how to get (Cell B) to be blank, when (Cell A) has no value in it, however
when Cell A has a value in it, I would like Cell B to show the value of a completed formula. ( from other cells on my spread sheet.?

I have been playing with the IF Blank ("","") , but if you place the formula between the "" is just ends up showing the formula typed out, not actually Completing the Formula and displaying the results?

any help or points in the right direction would be Greatly appreciated

 

[Joe4]

Welcome to the Board!

If on row 2, your formula for cell B2 should be structured something like:

=IF(A2="","",your formula)

 

[nedrockextreme]

Thank you very helpful

 

[Joe4]

You are welcome.
Glad I was able to help!