Posted by David Williams on June 17, 2001 8:11 PM
I enter a number from 0-29 into D1 the codes shows up in other cell but if I leave d1 blank the other cell G still shows the codes for the number 0. K column is numbers and L column is the code txt for the numbers I am sure this is function formula but how can I have the cell show no value if D1 is blank? I want to be able to hide K&L and it show up in G which it is doing right now except I need to have d blank and G show no valuesif no input. Hope I explained this well enough.