Thread: Hide the answer to an equation until all values are inputed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default 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?
Reply With QuoteReply With Quote