Need help (not sure how to explain in title)

P

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.
 
D

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.
 
F

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)
 
Top