Goal Seek in Excel

0 votes

Goal search in Excel doesn't seem to be working for me. When I run goal seek, I keep getting 113 years for some reason, and the payout is nowhere close to what I need it to be, which is 6250.

Even though I have experience with goal seek, I can't seem to get this one function.

image

Sep 29, 2022 in Others by Kithuzzz
 • 38,000 points • 1,048 views

1 answer to this question.

0 votes
The pmt function we are using, which spits out negative numbers to indicate payments, explains why the 6250 needs to be a -6250.
answered Sep 30, 2022 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
 • 23,260 points • 1,745 views
0 votes
1 answer

Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

answered Feb 9, 2022 in Others by gaurav
 • 23,260 points • 1,167 views
0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 647 views
0 votes
1 answer

Substring in excel

Hi Basically there is no specific formula ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 436 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 4,834 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 2,161 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
 • 13,690 points • 1,075 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
 • 23,260 points • 3,987 views
0 votes
1 answer

Excel Function Goal Seek Equivalent Algorithm in C #

Nuget has libraries available like Trident.GoalSeek and ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 1,804 views
0 votes
1 answer

How to use goal seek function in Excel user function?

In the Microsoft Excel Object-Sheet1(Sheet1), we can ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
 • 63,600 points • 846 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.