Worksheets/Forms
 

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?

Worksheets/Forms
 

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?

Worksheets/Forms
 

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?

Worksheets/Forms
 

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?

Worksheets/Forms
 

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?

Worksheets/Forms
 

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?

Worksheets/Forms
 

Sorry this still does not work, but thanks, decided to go with leaving
information in the C5 (protected info) and if D5 (variance info) changes to
have it work this way:

=IF(D5=0,C5,D5)*B5

This works perfect, if there is a new number put into D5 the formula
calulates that number and the number in B5 and puts only that number in E5.

Thanks for your help, just not working for me.


"CLR" wrote:

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?