Jump to content



Photo
- - - - -

Goal Seek In Spreadsheet


  • Please log in to reply
1 reply to this topic

#1 BennyDelon

BennyDelon

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 07 April 2015 - 02:31 PM

Hello.

 

I'm going to buy a Casio Classpad II but I was wondering if there is a "Goal Seek" tool in the Spreadsheet. I mean, something that can change the value of some cell until another target cell has the specified value.

 

I use that tool a lot in Excel.



#2 pan.gejt

pan.gejt

    Casio Freak

  • Members
  • PipPipPipPip
  • 123 posts
  • Gender:Male
  • Location:CZ

  • Calculators:
    fx-880, fx-6300G, fx-9700GE, fx-9860G Slim, Classpad 330-A, TI-Nspire + keypad, TI-Nspire CAS, TI-Nspire CX CAS,TI-89 Titanium, HP-50g, SEC-101, fx-991ES PLUS, fx-991DE PLUS, fx-CP400, Canon X MARK I PRO, Citizen SRP-75,

Posted 12 April 2015 - 05:57 AM

The Spreadsheet are very limited on each calc, practically it is suitable for statistical or basic table calculations. You shouldn't expect the Excel or LibreOffice Calc capabilities.

Each modern calculators have built-in solver application. The Classpad II has symbolic and numeric solver. The Numeric solver application is probably what you are looking for. Please, see the UG, Chapter 9 on page 178 or Examples book, Chapter 9 on the page 32.


  • BennyDelon likes this




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users