Making a cell appear blank

**fredlake** · 02-05-2010, 06:38 PM

as you can see, this sheet displays #N/A in cells that are waiting for input... I would like them to be blank until I enter the input info that would then display values into these cells... I tried this in cell m7 BUT as you can see in m12 it goes back to displaying the N/A.

I would like for cells k,l,m 7 to display blank until I enter the info into cell d,e,f,or g 7.

Hope I am making myself clear.

I had asked in a previous question and thought I had it resolved but it is still happening.

Thanx in advance

-=Fred=-

**jeffreybrown** · 02-05-2010, 07:22 PM

Does this work for you?

**fredlake** · 02-05-2010, 07:27 PM

You're the best!!!

Thanx for the help!

-=Fred=-

**jeffreybrown** · 02-05-2010, 07:30 PM

You're Welcome Fred

Let us know if there is anything else to help with

Remember to mark solved if question was answered satisfactorily

**jj72uk** · 02-05-2010, 07:31 PM

Various ways to do it.

You could conditional format it so:

Formula is =ISNA(cell reference)

And for the text colour to be the same as your background colour...

Or you could use:

=IF(ISERROR( formula ), "" , ( formula )

**fredlake** · 02-08-2010, 11:33 AM

Rocky or anyone else,

The file test%202 is looking great BUT I need L7 to also be empty, it now has a zero in it... once I enter info into d,e,f,or g 7 . I need L7 & M7 to be blank.

I haved played around with it to no avail. I hate that I am so exceliterate!

Thanx in advance

-=Fred=-

**DonkeyOte** · 02-08-2010, 11:53 AM

I'm not sure I follow requirements... in your original file L7 onwards contain no formulae - implying manual entry.

What is meant to happen exactly ?

K & M can be made to use IFERROR functions given you're use of XL2007, eg:

K7: =IFERROR((H7-I7)*10.69*I7,"")
copied down

M7: =IFERROR(IF(SUM(L7*K7)>=0.001,SUM(L7*K7),""),"")
copied down

L7 is as mentioned seemingly manual entry.
On that basis if you want 0 to be hidden from view you can apply a Custom Number Format to L7:L21 of: 0.00;(0.00);;
at which point 0's will no longer display