how do i hide value errors until data can be entered?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to set a sheet up as a template and until the data is entred, the
#value! shows in the cell -- i want it to be blank until each person is able
to input their data
 
Hi Cath

embed your current formula in a IF function e.g.
=IF(A1="","",current_formula)
or
=IF(ISBLANK(A1),"",current_formula)
or
=IF(ISERROR(current_formula),"",current_formula)
 
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

result should equal a blank field 2
Do not sum until cell has a value 3
subtract 2 cells and get blank instead of 0.0 3
Printing problems with hidden rows 1
ENTER DATA EXCELL SO RELATED DATA APPEARS 2
Creating a template that I can reproduce every month by keying ininformation from SAP 8
My Final #DIV/0! that I'd like to say Goodbye to! 20
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top