Hide the answer to an equation until all values are inputed

  • Thread starter Thread starter Anna
  • Start date Start date
A

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?
 
Say input cells are A1, A2, etc. then
=IF(OR(ISBLANK(A1),ISBLANK(A2), etc.),"",yourformula)

Regards,
Stefi

„Anna†ezt írta:
 
Smarter if precedents are in a contiguous range!
Stefi


„Max†ezt írta:
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Iterative Equation 5
Finding Equations 4
Excel 2007: continuously update scatter chart from scroll bars 1
Help with an equation 4
Equations appear as text 1
Continue equation 1
value based on count (equation question) 2

Back
Top