Need help (not sure how to explain in title)

[Plasma]

Okay, i have a forumla in C4 that pulls a number from A4 then does a
calculation. is there anyway to make it so nothing shows in the C4
column unless or until something is put into column A4?

i hope that makes sense. if not i'll try to describe it better.

 

[Guest]

something like this in C4
=IF(A4>0,a4,"")

 

[David McRitchie]

C4: =If(ISBLANK(A4),"",formula)

or if A4 just looks empty but may contain spaces
C4: =IF(TRIM(A4)="","",formula)

A cell with a formula will never be empty, so if you are trying to
reduce your used cell range this is not the solution.

 

[Faz]

Use conditional formatting on C4 (Format menu bar, Coditional
Formatting)

IF Formula Is: =A4=""

Format (Make cell invisible by making the font colour the same as
the cell background colour)