ExcelBanter - Excel: auto-repeat a value in different fields

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel: auto-repeat a value in different fields (https://www.excelbanter.com/excel-worksheet-functions/227401-excel-auto-repeat-value-different-fields.html)

Motorway Mike

Excel: auto-repeat a value in different fields

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.

T. Valko

Excel: auto-repeat a value in different fields

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.

All times are GMT +1. The time now is 06:47 PM.