| Computers Forum Index » Computer Applications - Spreadsheets » Quattro function does not function... |
|
Page 1 of 1 |
|
| Author |
Message |
| Don Phillipson... |
 Posted: Wed May 06, 2009 12:06 am |
|
|
|
Guest
|
In Quattro Pro.v.8
at (no spam) avg(C123..C132) does not function
i.e. this string just appears in the cell as text.
How can I make it take an average?
Help file says "You can use F9 to instantly calculate results of a formula "
but F9 on this cell does nothing: the text string remains.
F2 highlights (boxes) the array: but next CR does not calculate the average.
--
Don Phillipson
Carlsbad Springs
(Ottawa, Canada) |
|
|
| Back to top |
|
|
|
| d.... |
| Posted: Wed May 06, 2009 2:11 am |
|
|
|
Guest
|
"Don Phillipson" <e925 at (no spam) SPAMBLOCK.ncf.ca> wrote:
Quote: In Quattro Pro.v.8
at (no spam) avg(C123..C132) does not function
i.e. this string just appears in the cell as text.
How can I make it take an average?
Help file says "You can use F9 to instantly calculate results of a formula "
but F9 on this cell does nothing: the text string remains.
F2 highlights (boxes) the array: but next CR does not calculate the average.
--
Don Phillipson
Carlsbad Springs
(Ottawa, Canada)
It should work. Check that the target cell is not formatted as text.
All I can think of. |
|
|
| Back to top |
|
|
|
| Don Phillipson... |
| Posted: Wed May 06, 2009 4:25 pm |
|
|
|
Guest
|
"d." <d at (no spam) noospam.com> wrote in message
news:4a00b955.176425735 at (no spam) 216.168.3.70...
Quote: "Don Phillipson" <e925 at (no spam) SPAMBLOCK.ncf.ca> wrote:
In Quattro Pro.v.8
at (no spam) avg(C123..C132) does not function
i.e. this string just appears in the cell as text.
How can I make it take an average?
Help file says "You can use F9 to instantly calculate results of a
formula "
but F9 on this cell does nothing: the text string remains.
F2 highlights (boxes) the array: but next CR does not calculate the
average.
Quote: It should work. Check that the target cell is not formatted as text.
All I can think of.
OK: cell format was formerly "text," now is reset "User
defined" and function executes OK. (I can look deeper,
but this point seems omitted from on-line help.) Thank you.
DP |
|
|
| Back to top |
|
|
|
|
