Thread: Cell format for an array formula containing text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete Pete is offline
external usenet poster
  
Posts: 193
Default Cell format for an array formula containing text
I have the following array formula:

{=IF(G16=0,0&"
days",AVERAGE(IF((DrugList!F3:F72=FY!G3)*(DrugLis t!F3:F72<=FY!G4),DrugList!W3:W72))&" days")}

it returns the following value in the cell: 114.333333333333 days.

How can I get tha formula to return 114 days (no decimals)?

Pete.



Reply With QuoteReply With Quote