ExcelBanter - goal seek is not accurate

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - goal seek is not accurate (https://www.excelbanter.com/excel-programming/418626-goal-seek-not-accurate.html)

thread

goal seek is not accurate

Hi

i'm using goal seek to re-calculate a formula in order to get a cerain
precent
the problem is that sometime the results are in correct
for example:
i will request to get 1.15
and i will get 1.16

or i will request to get 2.25
and i will get 2.22

how can this issue can be resolved?

All times are GMT +1. The time now is 08:36 AM.