Copy formula without showing values?

[wacawacawallas]

I am trying to create a spreadsheet that is also "pretty" and am having some trouble. There will be rows where users can input information as they receive it, and then a few columns with formulas in them. Since the original cells will not have a value entered right away, is there a way to fill the formula down the column without actually showing the zero or generic date, etc.? Basically, have the cell hold a formula but appear blank?

Thank you for any help!

 

[HRIS]

I am trying to create a spreadsheet that is also "pretty" and am having some trouble. There will be rows where users can input information as they receive it, and then a few columns with formulas in them. Since the original cells will not have a value entered right away, is there a way to fill the formula down the column without actually showing the zero or generic date, etc.? Basically, have the cell hold a formula but appear blank?

Thank you for any help!

There may be a better way, but you could use an IF statement like
=IF(YourFormula=0,"",YourFormula)

So in place of your formula you would put the entire IF statement.

 

[danzon]

formula in B1

=IF(A1="","",your formula here)

so that if A1 is blank then B1 will be blank... but if A1 has a value, then your formula will be calculated

 

[HRIS]

There may be a better way, but you could use an IF statement like
=IF(YourFormula=0,"",YourFormula)

So in place of your formula you would put the entire IF statement.

Definitely use Danzon's idea if you would want 0 to show up when data was entered and the result was 0 - which would make sense!

 

[wacawacawallas]

Thank you! That worked perfectly.