Hiding functions in cells problem

[pyzikchr]

I have a large table with a rather long function in one column t
generate values. The function shows up in the cell unless there i
data in the two columns from which it draws data from to generate th
answer. How do I make the function disappear from the cell so that th
table will print out blank, but still have the function in the cell

Attachment filename: example2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64864

 

[Earl Kiosterud]

pyzikchr,

I suspect your function is actually a formula in the cell? What is it? And
it should return nothing in certain situations? Many won't open your
attachment.

 

[JulieD]

Hi

it's not the function that you're seeing but one of the parameters in the
function - the function itself is
=IF(OR(COUNTIF(C44,"DIE")<>1,C4="",D4=""),"Recheck entries in col C and/or
col D",OFFSET($K$3,MATCH(IF(D4<>"DIE",D4,C4),$J$4:$J$43,0),))

and what you're seeing is
"Recheck entries in col C and/or col D",
so if you don't want to see anything in the cell change the function to
=IF(OR(COUNTIF(C44,"DIE")<>1,C4="",D4=""),"",OFFSET($K$3,MATCH(IF(D4<>"DIE
",D4,C4),$J$4:$J$43,0),))

for column F change the formula to:

=IF(E4="",0,E4*0.345)

Regards
JulieD

 

[Frank Kabel]

Hi
maybe something like
=IF(OR(A1="",B1=""),"",Your_formula)

 

[Max]

Hi, you should stay within the same thread and as others have said,
make an effort to post your question in plain text ..

ok .. I missed out a check for blanks in *both* cols C and D
in the formula suggested in your earlier thread,
re: http://tinyurl.com/6u87l

The formula in that thread should hence have been:
[with: IF(AND(C6="",D6=""),"", ... added to the front]

In E6:

=IF(AND(C6="",D6=""),"",IF(OR(COUNTIF(C66,"A")<>1,C6="",D6=""),"Recheck
entries in col C and/or
col D",OFFSET($H$5,MATCH(IF(D6<>"A",D6,C6),$G$6:$G$10,0),)))

with E6 then copied down to E9
--
Since you have applied the suggested formula from that thread
in this new post, just add a check for blanks in *both* cols C and D
in the formula ..
(this'll take care of the default situation that no droplist selections
have yet been made in cols C and D, hence col E should remain blank)

Put in E4:

=IF(AND(C4="",D4=""),"",IF(OR(COUNTIF(C44,"DIE")<>1,C4="",D4=""),"Recheck
entries in col C and/or
col D",OFFSET($K$3,MATCH(IF(D4<>"DIE",D4,C4),$J$4:$J$43,0),)))

Copy E4 down

The "Recheck entries in col C and/or col D" is just an example
alert phrase which will show in the cell if the user were to make
incomplete or incorrect selections from the dv droplists in cols C and D
(You can change the phrase to better suit, if desired)