Thread: Spurious Formula Omits Adjacent Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default Spurious Formula Omits Adjacent Cells
Hi Walter

Yep, it also happens in xl2010 although you can make it disappear simply
by making the range absolute.

=Average($B1$1:$E$1)

HTH
Mick
Reply With QuoteReply With Quote