I've serached for about an hour so far and couldn't find an answer.
This may be a far stretch, so here goes.

I have a cell (B2) that is for entering data. I would like to have another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell B2')
and only if B3 is blank as well

Thank you in advance..
--
Not holding my breath

jsc3489 wrote...
....
I have a cell (B2) that is for entering data. I would like to have another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell B2')
and only if B3 is blank as well

A formula in B4 can't change the entry in cell B2 except by affecting a
formula in cell B2. Are you saying you want something to replace any
entry in cell B2 with "#" when either cell B1 or B3 (or both) contain
something other than ""?

when either cell B1 or B3 (or both) contain nothing

B1, B2 and B3 must be allowed to remain blank for data entry

however, you've answer my question which is 'no, it can't be done'

I was afraid so.
Thank you anyway..
--
me


"Harlan Grove" wrote:

jsc3489 wrote...
....
I have a cell (B2) that is for entering data. I would like to have another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell B2')
and only if B3 is blank as well

A formula in B4 can't change the entry in cell B2 except by affecting a
formula in cell B2. Are you saying you want something to replace any
entry in cell B2 with "#" when either cell B1 or B3 (or both) contain
something other than ""?

I've serached for about an hour so far and couldn't find an answer.
This may be a far stretch, so here goes.

I have a cell (B2) that is for entering data. I would like to have
another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell
B2')
and only if B3 is blank as well

Thank you in advance..
--
Not holding my breath


To the best of my knowlwge you cannot have one cell change another
without entering a formula into the cell to be changed.
=IF(B1&B2&B3="", "#","" will put a number chracter into the cell it
is entered in as long as cells B1:B3 are empty. If you put this
formula in cells B1, B2 or B3 you will get a "circular reference" error
and it will not work. It will work well if you put it into another cell
for example A1.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=392225

He didn't say it couldn't be done. He said it couldn't be done with a
formula.

However, based on your description to date, I think one would need to be a
mind reader to understand what you really want. You want to put a # in B2,
but B2 must remain blank . . .

What would trigger all this?
--
Regards,
Tom Ogilvy

"jsc3489" wrote in message
...
when either cell B1 or B3 (or both) contain nothing

B1, B2 and B3 must be allowed to remain blank for data entry

however, you've answer my question which is 'no, it can't be done'

I was afraid so.
Thank you anyway..
--
me


"Harlan Grove" wrote:

jsc3489 wrote...
....
I have a cell (B2) that is for entering data. I would like to have
another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell
B2')
and only if B3 is blank as well

A formula in B4 can't change the entry in cell B2 except by affecting a
formula in cell B2. Are you saying you want something to replace any
entry in cell B2 with "#" when either cell B1 or B3 (or both) contain
something other than ""?

Tom:

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell B2')
and only if B3 is blank as well

translation:
if B1 is blank and B3 is blank do nothing at all; end, else if B2 and B3 has
info, check if B2 is blank, if so, put a "#", if not, do nothing.

but I've gone past this issue and have re-directed to other means, such as:

=Choose(max(sumproduct(--(C24:C770),--(D24:D77="")),2)+1,"","Line
"&Sumproduct((--(C24:C770),--(D24:D77=""),row(D24:D77))&" is missing a
part number.", "Several lines are missing a part number")

but I'm getting errors :(

--
(O \ | / O) VW''''s rule because it''''s a car with camel toe ;)

jsc3489 wrote...
....
translation:
if B1 is blank and B3 is blank do nothing at all; end, else if B2 and B3 has
info, check if B2 is blank, if so, put a "#", if not, do nothing.
....

This is incoherent. If B2 and B3 both have info (which is the standard
meaning when you use 'and' rather than 'or'), there's no purpose served
checking whether B2 is blank - it can't be since it contains info, no?

What do you mean?

Oops!!

translation:
if B1 is blank and B3 is blank do nothing at all; end, else if B1 and B3 has
info, check if B2 is blank, if so, put a "#", if not, do nothing.

--
(O \ | / O) VW''''s rule because it''''s a car with camel toe ;)



"Harlan Grove" wrote:

jsc3489 wrote...
....
translation:
if B1 is blank and B3 is blank do nothing at all; end, else if B2 and B3 has
info, check if B2 is blank, if so, put a "#", if not, do nothing.
....

This is incoherent. If B2 and B3 both have info (which is the standard
meaning when you use 'and' rather than 'or'), there's no purpose served
checking whether B2 is blank - it can't be since it contains info, no?

What do you mean?