E
EC155 Pilot
I have an excel spreadsheet that utilizes "IF" Function Arrays in cell
A2 to identify a response to a given value in the cell A1. When I
load this onto my pocket pc all seems well. The resultant value
within cell A2 with the "IF" Function Arrays is the same as it was on
my laptop. When I change the value in cell A1 it should come up with
a new number based on the logic in the "IF" Function Arrays however
once I change the value in cell A1 on pocket excel the result in cell
A2 changes to 0 regardless of the value in cell A1.
Two questions:
1. Does Pocket Excel recognize "IF" Function Arrays? (note: MS Excel
will not permit more than 8 "IF" Functions within one cell)
2. Am I suppose to prompt pocket excel to recalculate when long
functions are used? If so, how?
A2 to identify a response to a given value in the cell A1. When I
load this onto my pocket pc all seems well. The resultant value
within cell A2 with the "IF" Function Arrays is the same as it was on
my laptop. When I change the value in cell A1 it should come up with
a new number based on the logic in the "IF" Function Arrays however
once I change the value in cell A1 on pocket excel the result in cell
A2 changes to 0 regardless of the value in cell A1.
Two questions:
1. Does Pocket Excel recognize "IF" Function Arrays? (note: MS Excel
will not permit more than 8 "IF" Functions within one cell)
2. Am I suppose to prompt pocket excel to recalculate when long
functions are used? If so, how?