+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Spreadsheet: I can't use solve() (/thread-4887.html)
Spreadsheet: I can't use solve() - Macund - 10-05-2015 05:43 PM
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().
RE: Spreadsheet: I can't use solve() - cyrille de brébisson - 10-06-2015 05:41 AM
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