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.

Cell format for an array formula containing text
 

Use the INT function.

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

--
Best Regards,

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


"Pete" wrote:

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.

Cell format for an array formula containing text
 

Thanks it worked grat!.

Pete

"Luke M" wrote:

Use the INT function.

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

--
Best Regards,

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


"Pete" wrote:

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.