To test for two cells being blank, do something like the following:
=IF(ISBLANK(A1:A2),"blank","not blank")

This is an array formula and needs to be entered with CTRL + SHIFT + ENTER

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Solograndma" wrote:

Solograndma back with another complicated formula problem.
In my workbook I have a data entry sheet that transfers data to a printable
sheet. I have a copy and paste function with mid-range formulas for and
address as well as a manual entry area. I have the formula to use the pasted
information if it's there or the manually entered information if it is there.
What I need is for the cells in the printable page to be blank if both the
pasted and the manual entry areas are blank. Everything I have tried brings
back zeros and unfortunately this form nees to be able to be printed as a
blank form for hand written use. I truly appreciate any help available. This
message board has been great so far. Thanks.