|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2009, 08:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
April 15th, 2009, 08:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
April 15th, 2009, 08:56 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
