Cell format for an array formula containing text

[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.

 

[Luke M]

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")}

 

[Pete]

Thanks it worked grat!.

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")}

--
Best Regards,

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