Formatting a calculated value in a cell
Thank you.
It worked.
"Bill Kuunders" wrote:
add round(...................................,2)
to your formula
you'll get
=ROUND(AVERAGE(IF(WEEKDAY(Seven)=WEEKDAY($B283),$B $3:$B$262)),2)
&" per "&TEXT($B283,"dddd")
--
Greetings from New Zealand
"Tim" wrote in message
...
I have the following array formula (Excel 2003) in a cell:
=AVERAGE(IF(WEEKDAY(Seven)=WEEKDAY($B283),$B$3:$B$ 262))&" per
"&TEXT($B283,"dddd")
where "Seven" is a named range for all the days in the year 2007 & column
B
has the production #s for each day & B283 to B289 has the days of the
week.
This gives the answer I am looking for:
76.2307692307692 per Monday
However, how can I format the output to 2, or 3, decimal places?
Format, Cells, Number does not work and I cannot come up with a custom
format either.
Thank you
|