View Single Post
  #7   Report Post  
njmikec njmikec is offline
Junior Member
 
Posts: 2
Smile

Had the same problem just now. Excel 2003 SP3. Formula in G2 was =IF(ISBLANK(F2),B2,F2). Fairly simple.

AutoCalc set to ON. F9 did nothing. Shift+F9 did nothing. Alt+Shift+F9 did nothing, etc.

Even though F2 is blank, until I actually placed the cursor in the formula bar and hit enter, the formula in G2 did not display the needed value.

Workaround that worked for me was to sort so that all blank F column cells were easily accessible, place the cursor in the formula bar and hit enter in one cell (F2 for example). Copy F2 and Paste Special/Values in the remaining blank F column cells.

This worked for me. Hope it works for you too. All the best -