cancel
Showing results for
Did you mean:
Level 3
45 19 1 1
Message 1 of 3
1,421
Flag Post

Solved!

RE: Eulers Method on HP Prime

HP Recommended
HP Prime

Hi,

How do you insert a formula into a Spreadsheet on the HP Prime Calculator?

For example, with xi, how do I insert a formula that is = previous xi value + 0.1?

Regards,

Arthur

Tags (1)
2 REPLIES 2
Level 8
622 609 117 207
Message 2 of 3
Flag Post
HP Recommended

I hope a simple example helps:

(1) Type 1 into cell A1.

(2) Type =A1+.01 into cell A2 (include the = sign; see 1.01 result)

(3) Click on cell A2 to select it.

(4) Shift View (Copy).

(5) Click on cell A3 to select it.

(6) Click Select, Go To, type A7 and press Enter (see 5 cells selected).

(8) Click the top item in the Paste menu (item 1, which is 1.01)

(9) Click option 2 (the "Formula" option). See 1.02 through 1.06 appear.

(10) Click any cell (or the bulleted Select button) to turn off Select mode.

Recap:  reference cells by name; start formulas with an = sign; and propagate formulas by pasting cells as formulas.

Quiz: Generate the Fibonacci Sequence (1, 1, 2, 3 ,5, ...) using Prime's Spreadsheet. Each number in the Fibonacci Sequence is the sum of the previous two, with the first two being defined as 1 and 1.

-Joe-
Tags (1)
Level 3
45 19 1 1
Message 3 of 3
Flag Post
HP Recommended

Thank you Joe

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation