Array formula on Pocket PC

[Eric G]

Hello,

I'm trying to get an array formula to work on my WM2003SE pocket pc.
Right now if I put the cursor in the edit box and hit CTRL-SHFT and
Enter I don't get curly brackets in the formula and it gives results
in the cells such as #VALUE!.

Please tell me "no problem, here's how to fix that"
rather than "sorry you can't do that with pocket excel on pocket pcs".


First I tried just copying the spreadsheet from my desktop to the
pocket pc but the formulas didn't transfer, so I painstakingly entered
them manually.

Eric

[Peo Sjoblom]

Sorry to disappoint you but array formulas don't work on pocket Excel

--
Regards,

Peo Sjoblom

(No private emails please)


"Eric G" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I'm trying to get an array formula to work on my WM2003SE pocket pc.
> Right now if I put the cursor in the edit box and hit CTRL-SHFT and
> Enter I don't get curly brackets in the formula and it gives results
> in the cells such as #VALUE!.
>
> Please tell me "no problem, here's how to fix that"
> rather than "sorry you can't do that with pocket excel on pocket pcs".
>
>
> First I tried just copying the spreadsheet from my desktop to the
> pocket pc but the formulas didn't transfer, so I painstakingly entered
> them manually.
>
> Eric
>
>

[Eric G]

On Fri, 7 Oct 2005 20:11:59 -0700, "Peo Sjoblom" <[email protected]>
wrote:

>Sorry to disappoint you but array formulas don't work on pocket Excel

Well that's really a shame. I guess it shows what MS thinks of pocket
Excel users in general.

Anyways, what workaround might be used to calculate the following
formula in pocket Excel?

{=AVERAGE(IF((C4:M4<>"")*(C$2:M$2<>""),C4:M4/C$2:M$2))*100}

Thanks!

Eric

[Peo Sjoblom]

Although I have a pocket pc I never really use excel except when I first got
it and soon realized it was of little help but in general you have to use
multiple formulas, i.e.

=IF(AND(C4<>"",C2<>""),C4/C2)

copy across 6 columns

assume you put that and copy across from C8 to H8 thus instead of using an
array calculate each cell individually, then finish off with

=AVERAGE(C8:H8)*100

which should give the same answer

--
Regards,

Peo Sjoblom

(No private emails please)


"Eric G" <[email protected]> wrote in message
news:[email protected]...
> On Fri, 7 Oct 2005 20:11:59 -0700, "Peo Sjoblom" <[email protected]>
> wrote:
>
>>Sorry to disappoint you but array formulas don't work on pocket Excel
>
> Well that's really a shame. I guess it shows what MS thinks of pocket
> Excel users in general.
>
> Anyways, what workaround might be used to calculate the following
> formula in pocket Excel?
>
> {=AVERAGE(IF((C4:M4<>"")*(C$2:M$2<>""),C4:M4/C$2:M$2))*100}
>
> Thanks!
>
> Eric

[Eric G]

On Fri, 7 Oct 2005 20:41:21 -0700, "Peo Sjoblom" <[email protected]>
wrote:


OK thanks very much Peo I'll give that a shot.
It should work out just fine.

Eric



>Although I have a pocket pc I never really use excel except when I first got
>it and soon realized it was of little help but in general you have to use
>multiple formulas, i.e.
>
>=IF(AND(C4<>"",C2<>""),C4/C2)
>
>copy across 6 columns
>
>assume you put that and copy across from C8 to H8 thus instead of using an
>array calculate each cell individually, then finish off with
>
>=AVERAGE(C8:H8)*100
>
>which should give the same answer