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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
message
>news:[email protected]...
>> 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" <[email protected]> wrote
in message
>> > news:AEB11346-A4D9-4D30-93C1-
[email protected]...
>> > > 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.
>> >
>> >
>> >
>
>
>.
>