Enter this formula in F20:

=IF(AND(C20<"",D20<""),C20,"")

--
Biff
Microsoft Excel MVP


"Motorway Mike" wrote in message
...
Excel 2007 :
How do I get Excel to automatically repeat in (say) F20 the same value as
in
(say) C20, IF there is an entry in (say) D20, but NOT if D20 is blank ?
Thanks.