I have a worksheet with pre-filled info, but if there is a variance to that
info placed in a different box, how do I get the pre-filled one to disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if D is
filled with a number, how do I get C to "hide" or disappear?

The preset value could be entered as a formula which would result in an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

I have a worksheet with pre-filled info, but if there is a variance to that
info placed in a different box, how do I get the pre-filled one to disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if D is
filled with a number, how do I get C to "hide" or disappear?

I tried this and it did not work. I am really a beginner at this excel stuff
and hate to say but really need spelled out exactly:
my worksheet is a continuous one, repeats same columns over 18 pages.
The info I need starts in column C5 (which has a number in it that needs to
stay and be protected) - but right next to it is D5 which has nothing in it
until someone changes the numbered amount in C as in C now is a 10, if they
need more than 10 or less then 10 they would put in column D. I need at this
point for the 10 in C is hide or disappear for this transaction only.

Does that make sense?

"CLR" wrote:

The preset value could be entered as a formula which would result in an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

I have a worksheet with pre-filled info, but if there is a variance to that
info placed in a different box, how do I get the pre-filled one to disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if D is
filled with a number, how do I get C to "hide" or disappear?

Put this formula in cell C5....it contains your preset 10 amount......but
will not be visible if something is entered in D5


=IF(LEN(D50,"",10)

Vaya conDios,
Chuck, CABGx3

"pattyh" wrote in message
...
I tried this and it did not work. I am really a beginner at this excel
stuff
and hate to say but really need spelled out exactly:
my worksheet is a continuous one, repeats same columns over 18 pages.
The info I need starts in column C5 (which has a number in it that needs
to
stay and be protected) - but right next to it is D5 which has nothing in
it
until someone changes the numbered amount in C as in C now is a 10, if
they
need more than 10 or less then 10 they would put in column D. I need at
this
point for the 10 in C is hide or disappear for this transaction only.

Does that make sense?

"CLR" wrote:

The preset value could be entered as a formula which would result in an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

I have a worksheet with pre-filled info, but if there is a variance to
that
info placed in a different box, how do I get the pre-filled one to
disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if
D is
filled with a number, how do I get C to "hide" or disappear?

I tried this and it still comes back with an error, something to do with the
"". It is not working.

"CLR" wrote:

Put this formula in cell C5....it contains your preset 10 amount......but
will not be visible if something is entered in D5


=IF(LEN(D50,"",10)

Vaya conDios,
Chuck, CABGx3

"pattyh" wrote in message
...
I tried this and it did not work. I am really a beginner at this excel
stuff
and hate to say but really need spelled out exactly:
my worksheet is a continuous one, repeats same columns over 18 pages.
The info I need starts in column C5 (which has a number in it that needs
to
stay and be protected) - but right next to it is D5 which has nothing in
it
until someone changes the numbered amount in C as in C now is a 10, if
they
need more than 10 or less then 10 they would put in column D. I need at
this
point for the 10 in C is hide or disappear for this transaction only.

Does that make sense?

"CLR" wrote:

The preset value could be entered as a formula which would result in an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

I have a worksheet with pre-filled info, but if there is a variance to
that
info placed in a different box, how do I get the pre-filled one to
disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if
D is
filled with a number, how do I get C to "hide" or disappear?

Sorry Pattyh, my bad......formula should be....

=IF(LEN(D5)0,"",10)

Vaya con Dios,
Chuck, CABGx3




"pattyh" wrote in message
...
I tried this and it still comes back with an error, something to do with
the
"". It is not working.

"CLR" wrote:

Put this formula in cell C5....it contains your preset 10
amount......but
will not be visible if something is entered in D5


=IF(LEN(D50,"",10)

Vaya conDios,
Chuck, CABGx3

"pattyh" wrote in message
...
I tried this and it did not work. I am really a beginner at this
excel
stuff
and hate to say but really need spelled out exactly:
my worksheet is a continuous one, repeats same columns over 18 pages.
The info I need starts in column C5 (which has a number in it that
needs
to
stay and be protected) - but right next to it is D5 which has nothing
in
it
until someone changes the numbered amount in C as in C now is a 10, if
they
need more than 10 or less then 10 they would put in column D. I need
at
this
point for the 10 in C is hide or disappear for this transaction only.

Does that make sense?

"CLR" wrote:

The preset value could be entered as a formula which would result in
an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

I have a worksheet with pre-filled info, but if there is a
variance to
that
info placed in a different box, how do I get the pre-filled one to
disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not
protected, if
D is
filled with a number, how do I get C to "hide" or disappear?