Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how can it be performed

  Asked By: Kiral    Date: Feb 08    Category: MS Office    Views: 603
  

I am working on a spreadsheet. in which, i have tables which are
dependent on respective cells. Each tables represents each cells. & the
table is wholly formulated.

i want to perform that if the cell is blank, then the respective table
should also be remains blank. & if the cell is filled then the table
should also be filled with respective formulas.

if it is done then it can be very useful in reatative & tedious work
that adding required tables or deleting unrequired tables

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Daimon Jones     Answered On: Feb 08

There are so many ways to manage this. The easiest I think is to just
apply Conditional Formatting to the Table. If the Cell is blank  apply
a font color that is the same as the background.

 
Answer #2    Answered By: Aabirah Khan     Answered On: Feb 08

You could use formulas  in your cells  like:

=if(A1="","",A1*B1)

This will put a blank  in the cell  if A1 is blank, and the result of the
formula if A1 is not blank.

 
Didn't find what you were looking for? Find more on how can it be performed Or get search suggestion and latest updates.




Tagged: