Thread: #value! on spreadsheet when formula palette gets correct result
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wingham wingham is offline
external usenet poster
  
Posts: 2
Default #value! on spreadsheet when formula palette gets correct result
=AVERAGE(IF(C5:C14="Europe",D5:D14)), an example in the help, gives correct
result within the palette formula editor, but the #value! is all that shows
up in the spreadsheet.
Reply With QuoteReply With Quote