| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Auto Populate Fields | New Users to Excel | |||
| Auto populating excel fields | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Auto-Enter Text in Excel Fields | Excel Discussion (Misc queries) | |||
| Excel,Auto fit - does work for large text fields | Excel Discussion (Misc queries) | |||
Linear Mode
