carlos

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Carlos

Carlos

resolvedResolved · Medium Priority · Version 2007

Claudio has attended:
Excel Advanced course

Carlos

Goal Seek tryin to have as answer a PERCENTAGE

Goal Seek

Hi Claudio

Goal Seek is a What-If Analysis tool in Excel.

With Goal Seek you can set a formula to a new value (Goal) and then specify which one of the cells that the formula referenced as the cell to be adjusted.

If the selected cell is formatted as a percentage them you can enter the new Goal in the Set Value box as a percentage. The computer will take it into account in the calculation.

Hope this helps

Carlos


 

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips


Server loaded in 0.12 secs.