Need help (not sure how to explain in title)

  • Thread starter Thread starter Plasma
  • Start date Start date
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.
 
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.
 
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)
 
Back
Top