Spreadsheet: I can't use solve() - Printable Version +- 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 |