If function clarification
 

I have a column in which some of the cells have input values, and some don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.

It's better that you continue in the original thread you started


in E1 put

=IF(F1="",F1,"")

--

Regards,

Peo Sjoblom



"jmcclain" wrote in message
...
I have a column in which some of the cells have input values, and some
don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.

Thanks - however, column E has values in all cells and I need to maintain
them. My goal is to simply copy the value in E1 iinto F1 if there is not
value in F1.

Thanks

"Peo Sjoblom" wrote:

It's better that you continue in the original thread you started


in E1 put

=IF(F1="",F1,"")

--

Regards,

Peo Sjoblom



"jmcclain" wrote in message
...
I have a column in which some of the cells have input values, and some
don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.

Then it is not possible unless you use event macros

http://www.cpearson.com/excel/events.htm

--

Regards,

Peo Sjoblom

"jmcclain" wrote in message
...
Thanks - however, column E has values in all cells and I need to maintain
them. My goal is to simply copy the value in E1 iinto F1 if there is not
value in F1.

Thanks

"Peo Sjoblom" wrote:

It's better that you continue in the original thread you started


in E1 put

=IF(F1="",F1,"")

--

Regards,

Peo Sjoblom



"jmcclain" wrote in message
...
I have a column in which some of the cells have input values, and some
don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the
values
currently in column F

Any assistance would be great.

Hi

It's possible stepwise.

Into some free column enter formulas like
=IF(F1="",F1,E1)
Copy the range with formulas, and Paste Special as values into column F (you
overwrite your old data)
Delete formulas you entered before.


Arvi Laanemets


"jmcclain" wrote in message
...
I have a column in which some of the cells have input values, and some
don't.

I need to have someway of having excel do the following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this without "typing" over the values
currently in column F

Any assistance would be great.

Or use another column
=if(F1="",E1,F1)
then copy the column and paste values in column F
-----Original Message-----
Then it is not possible unless you use event macros

http://www.cpearson.com/excel/events.htm

--

Regards,

Peo Sjoblom

"jmcclain" wrote in
message
...
Thanks - however, column E has values in all cells and
I need to maintain
them. My goal is to simply copy the value in E1 iinto
F1 if there is not
value in F1.

Thanks

"Peo Sjoblom" wrote:

It's better that you continue in the original thread
you started


in E1 put

=IF(F1="",F1,"")

--

Regards,

Peo Sjoblom



"jmcclain" wrote
in message
news:AEB11346-A4D9-4D30-93C1-
...
I have a column in which some of the cells have
input values, and some
don't.

I need to have someway of having excel do the
following:

If F1 has a value, do nothing
If F1 is blank, insert the value in cell E1.

However, AI am not sure how to do this
without "typing" over the
values
currently in column F

Any assistance would be great.





.