IF function help needed

[jmcclain]

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

 

[JulieD]

Hi

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

Cheers
JulieD

 

[Jeff]

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