Hide the answer to an equation until all values are inputed

[Anna]

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?

 

[Stefi]

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

Regards,
Stefi

„Anna†ezt írta:

 

[Max]

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

 

[Stefi]

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

 

[Stefi]

Smarter if precedents are in a contiguous range!
Stefi


„Max†ezt írta:

 

[Max]

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

 

[Stefi]

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: