Cell format for an array formula containing text

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I have the following array formula:

{=IF(G16=0,0&"
days",AVERAGE(IF((DrugList!F3:F72>=FY!G3)*(DrugList!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.
 
Use the INT function.

{=IF(G16=0,0&"
days",INT(AVERAGE(IF((DrugList!F3:F72>=FY!G3)*(DrugList!F3:F72<=FY!G4),DrugList!W3:W72)))&" days")}
 
Thanks it worked grat!.

Pete

Luke M said:
Use the INT function.

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 
Back
Top