| Home |
| Search |
| Today's Posts |
|
#3
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup where table array is in text format | Excel Worksheet Functions | |||
| text and formula in the same cell - how do I format this cell?? | Excel Discussion (Misc queries) | |||
| How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
| a text array formula | Excel Worksheet Functions | |||
| How do I use cond format formula to set cell text and color? | Excel Discussion (Misc queries) | |||
Threaded Mode
