IF function help needed

I need to use an IF function to do the following:

If cell F1 is empty, then insert the value from E1
If cell F1 has any value, do nothing

Can someone assist with the proper syntax?

Thanks

Insert this formula on E1
=IF(F1="",F1,"")



"jmcclain" wrote:

> I need to use an IF function to do the following:
>
> If cell F1 is empty, then insert the value from E1
> If cell F1 has any value, do nothing
>
> Can someone assist with the proper syntax?
>
> Thanks

Hi

if you want this in say G1 the formula would be
=IF(ISBLANK(F1),E1,"")
or
=IF(F1="",E1,"")

Cheers
JulieD


"jmcclain" <jmcclain@discussions.microsoft.com> wrote in message
news:FE9CF12D-C889-4FF0-A3DB-5DCB5CC46DF4@microsoft.com...
>I need to use an IF function to do the following:
>
> If cell F1 is empty, then insert the value from E1
> If cell F1 has any value, do nothing
>
> Can someone assist with the proper syntax?
>
> Thanks