Hide the answer to an equation until all values are inputed
 

I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet.

Anyone know how to do this?

Hide the answer to an equation until all values are inputed
 

Say input cells are A1, A2, etc. then
=IF(OR(ISBLANK(A1),ISBLANK(A2), etc.),"",yourformula)

Regards,
Stefi

€žAnna€� ezt Ã*rta:

I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet.

Anyone know how to do this?

Hide the answer to an equation until all values are inputed
 

Another option
In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula)
where formula precedents are A1,B1,C1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Anna" wrote:
I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet.

Anyone know how to do this?

Hide the answer to an equation until all values are inputed
 

Smarter!
Stefi


€žMax€� ezt Ã*rta:

Another option
In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula)
where formula precedents are A1,B1,C1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Anna" wrote:
I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet.

Anyone know how to do this?

Hide the answer to an equation until all values are inputed
 

Smarter if precedents are in a contiguous range!
Stefi


€žMax€� ezt Ã*rta:

Another option
In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula)
where formula precedents are A1,B1,C1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Anna" wrote:
I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet.

Anyone know how to do this?

Hide the answer to an equation until all values are inputed
 

"Stefi" wrote:
Smarter if precedents are in a contiguous range!

But it works even for discontiguous ranges, Stefi,
eg: =IF(COUNTA(A1:C1,A3,C3:C4)<6,"",<formula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---

Hide the answer to an equation until all values are inputed
 

Yes, that's true. Another idea for Anna to make still simpler the formula:
create a named range consisting of precedent cells, say "precedents", in this
case the formula:
=IF(COUNTA(precedents)<6,"",<formula)

Stefi

€žMax€� ezt Ã*rta:

"Stefi" wrote:
Smarter if precedents are in a contiguous range!

But it works even for discontiguous ranges, Stefi,
eg: =IF(COUNTA(A1:C1,A3,C3:C4)<6,"",<formula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---