HP Forums

Full Version: Spreadsheet: I can't use solve()
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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().
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
Reference URL's