Thread: [Solved] Formula shows the same value in all cells instead of updating as per forumla...
View Single Post
 
Old 05-25-2018, 03:04 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2013
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Formula shows the same value in all cells instead of updating as per forumla...
When I try to drag this formula to get the column updated with this formula in cell, it is just copying the same date in all cells. But whenever I double-click on any cell it is get updated.

The columns AA2 & P2 formatted as date (28-May-2018)

=IF(AA2<>"",AA2,P2)

Please support.
Reply With Quote