View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

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

Cheers
JulieD


"jmcclain" wrote in message
...
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