Rounded Result with Goal Seek

[Crownman]

When I use Goal Seek, the result cell returns a calculated value of,
for example, 55.6138. I would like to have this value rounded to 2
decimal places i.e. 55.61. Does anyone know a method by which this
can be accomplished?

Thanks for any help,

Crownman

 

[starguy]

suppose you get this value in cell A5, format this cell for 2 decima
places.
right click on cell A5, select format cells..., from category lis
select numbers and at right side change decimal places to 2.

hope this would help.

 

[Crownman]

Thanks for the suggestion, but I apparently did not correctly describe
the issue.

I already have cell A5 formatted for 2 decimal places and 55.61 is what
shows up in that cell, but the actual value in the cell is 55.6138. I
need to get an actual value of 55.6100.

Crownman

 

[starguy]

try to change the values in other cells by decimal places and check fo
the results.

 

[Crownman]

No success here either. The 'Precision As Displayed' calculation
option looks to solve the problem, but I'm not sure about what it would
do to the accuracy of the spreadsheet over time. None of the cells in
the spreadsheet use more than 4 decimal places. Can anyone give me any
advice?

Crownman

 

[Niek Otten]

If the 55.6138 is in cell A1, put this formula in another cell:

=ROUND(A1,2) and use that as your final result.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| When I use Goal Seek, the result cell returns a calculated value of,
| for example, 55.6138. I would like to have this value rounded to 2
| decimal places i.e. 55.61. Does anyone know a method by which this
| can be accomplished?
|
| Thanks for any help,
|
| Crownman
|

 

[Crownman]

Another good thought, but there are about 200 cells that potentially
could be calculated via goal seek and each of these drive several other
calculations. I have experimented with 'Precision As Displayed' and
this looks to be my solution.

Thanks to all for your help.

Crownman

 

[Niek Otten]

Fine, if you tested your workbook to function correctly with that option. For many financial problems this is an excellent
solution.
Be aware that "precision as displayed" is a misleading wording; it should be "precision as formatted". So if your cell is just
wide enough to show two digits, but is formatted as General, it is not rounded to those two digits, only if explicitly formatted
for two digits.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Another good thought, but there are about 200 cells that potentially
| could be calculated via goal seek and each of these drive several other
| calculations. I have experimented with 'Precision As Displayed' and
| this looks to be my solution.
|
| Thanks to all for your help.
|
| Crownman
| Niek Otten wrote:
| > If the 55.6138 is in cell A1, put this formula in another cell:
| >
| > =ROUND(A1,2) and use that as your final result.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | When I use Goal Seek, the result cell returns a calculated value of,
| > | for example, 55.6138. I would like to have this value rounded to 2
| > | decimal places i.e. 55.61. Does anyone know a method by which this
| > | can be accomplished?
| > |
| > | Thanks for any help,
| > |
| > | Crownman
| > |
|