I'm having trouble figuring out how to properly do an =IF to make this work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327), but
I know the false is wrong. How do I accomplish this?

This is the formula

If(B327="",E327,B327)

Michael Arch

Please rate posting if helpful





"blucajun" wrote:

I'm having trouble figuring out how to properly do an =IF to make this work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327), but
I know the false is wrong. How do I accomplish this?

Try it the other way round:

=IF(B327<"", B327,E327)

or

=IF(B327="",E327,B327)

--
HTH

Sandy
In Perth, the ancient capital of Scotlandand the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"blucajun" wrote in message
...
I'm having trouble figuring out how to properly do an =IF to make this
work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it
is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327),
but
I know the false is wrong. How do I accomplish this?

I already tried that formula -it creates a circular reference and gives me a
zero...

"Michael" wrote:

This is the formula

If(B327="",E327,B327)

Michael Arch

Please rate posting if helpful





"blucajun" wrote:

I'm having trouble figuring out how to properly do an =IF to make this work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327), but
I know the false is wrong. How do I accomplish this?

Do you have the formula placed in B327, this will be the reason for the
circular reference. The if statement must be in a differente cell. What you
can do if you only need one column with data is to place the formula on G327
for example and hide columns B through F.

You can not however have a formula referencing the same cell where the
formula resides, this creates the circular reference error.

Regards,

Michael Arch.

Rate this posting if helpful.







"blucajun" wrote:

I already tried that formula -it creates a circular reference and gives me a
zero...

"Michael" wrote:

This is the formula

If(B327="",E327,B327)

Michael Arch

Please rate posting if helpful





"blucajun" wrote:

I'm having trouble figuring out how to properly do an =IF to make this work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327), but
I know the false is wrong. How do I accomplish this?

"blucajun" wrote in message
...
I already tried that formula -it creates a circular reference and gives me
a
zero...

I assume then that E327 refers to the cell in which the formula is located?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Ahhh, that's what I was doing wrong. I was wanting to put the forumla in
column B. Silly me. Thanks!!

"Michael" wrote:

This is the formula

If(B327="",E327,B327)

Michael Arch

Please rate posting if helpful





"blucajun" wrote:

I'm having trouble figuring out how to properly do an =IF to make this work
the way I need. I have text in columns B & E, but some of the cells in
column B are empty. I need a formula that will look at column B and if it is
empty, copy the data from column E. If the cell in column B is not empty,
then keep what it already has. I tried using =IF(B327<"", E327, B327), but
I know the false is wrong. How do I accomplish this?