M
mcr1
You guys have been so helpful, and I sure do appreciate everything you
all have done to each me about Excel. Thanks.
The formula in G14 is =B14. There will always be a value in B14. I
only want G14 to equal B14 is there is a specific value in F6. If
there is not the value that I want in F6, I want G14 to remain blank
and not copy the contents of B14 into G14.
For example:
If F6=n12345 then G14 = B14.
If F6=n567AB then G14 = B14.
but,
If F6=n6609K then G14 should not copy B14 and stay blank.
or
If F6=n145AB then G14 should not copy B14 and stay blank.
There are maybe 5 nXXXXX that I would need this to happen for, so if 1
of these 5 values appear in F6, then I want G14 to equal the contents
B14, all the while keeping the formula of G14 equaling B14. If there
is is nothing in G14, I want the space to remain completely blank, no
"0", no "#N/A", no nothing. As always, thanks in advance
guys................
mcr1
all have done to each me about Excel. Thanks.
The formula in G14 is =B14. There will always be a value in B14. I
only want G14 to equal B14 is there is a specific value in F6. If
there is not the value that I want in F6, I want G14 to remain blank
and not copy the contents of B14 into G14.
For example:
If F6=n12345 then G14 = B14.
If F6=n567AB then G14 = B14.
but,
If F6=n6609K then G14 should not copy B14 and stay blank.
or
If F6=n145AB then G14 should not copy B14 and stay blank.
There are maybe 5 nXXXXX that I would need this to happen for, so if 1
of these 5 values appear in F6, then I want G14 to equal the contents
B14, all the while keeping the formula of G14 equaling B14. If there
is is nothing in G14, I want the space to remain completely blank, no
"0", no "#N/A", no nothing. As always, thanks in advance
guys................
mcr1