Spreadsheet: I can't use solve()
10-05-2015, 05:43 PM
Post: #1
 Macund Junior Member Posts: 2 Joined: Oct 2015
Spreadsheet: I can't use solve()
Thanks for read and sorry i'm not good speaking english.I trying to use solve() writing on cells and program but don't give me the answer. Example:
When i write =solve( B+34=0,B) give me {B}
When i write =rp(A1,A2,A3) give me {B}

EXPORT rp(A,C,D)
BEGIN
LOCAL E1;
200/(('B'-A)*(C*'B'-A))=D▶E1;
RETURN solve(E1,'B');
END;

What i can do ? When i change RETURN solve(E1,'B') to RETURN E1. Hp write the equation whith the numeric valors.For that i think i use wrong solve().
10-06-2015, 05:41 AM
Post: #2
 cyrille de brébisson Senior Member Posts: 975 Joined: Dec 2013
RE: Spreadsheet: I can't use solve()
Hello,

In the spreadsheet, A1 cell, type:
=solve(B+34=0, B)
BUT BEFORE YOU PRESS ENTER, click/select on the CAS menu (so that the cell is evaluated using the CAS).
You should get {-34} as the cell value (the cas solve function returns the result in a list because it can solve for more than 1 variable at once).

You can also type:
=Solve.SOLVE(B+34=0,B) (AND MAKE SURE THAT CAS IS NOT CHECKED)
to use the SOLVE function from the Solve app. This will return -34 for the cell

Hope this helps

Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP.
 « Next Oldest | Next Newest »

User(s) browsing this thread: 1 Guest(s)