Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array formula on Pocket PC
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 |
#2
|
|||
|
|||
Sorry to disappoint you but array formulas don't work on pocket Excel
-- Regards, Peo Sjoblom (No private emails please) "Eric G" wrote in message ... 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 |
#3
|
|||
|
|||
On Fri, 7 Oct 2005 20:11:59 -0700, "Peo Sjoblom"
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 |
#4
|
|||
|
|||
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" wrote in message ... On Fri, 7 Oct 2005 20:11:59 -0700, "Peo Sjoblom" 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 |
#5
|
|||
|
|||
On Fri, 7 Oct 2005 20:41:21 -0700, "Peo Sjoblom"
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formula | Excel Discussion (Misc queries) | |||
referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |