Forum Discussion
Goal seek not giving the answer
Excel designed for getting specific number by changing only
one cell. First you need to set cell i.e.B4 then to value 10 and finally
give cell reference in by changing cell address B2 or B3. There must be
formula for total in B4 to get adjusted. We have given target value 10,
then B3 value will be changed to 6.
sivakumarrj Yes, thx siva, but i've done exacly as you have, where in cell B4 i add cell B3 and B2, and do exacly as you do, but mine doesn't change the number, it only says that it has found a solution. You can see down below. When im on my desktop (macbook air 2020 m1 chip) it doesn't work. But when im on my computer at home it works just fine, and changes the number. I think it is somewhere in excel settings with goal seek that there is a problem. Because it doesn't show me the answear, just that it found a solution.
https://paste.pics/9874fb69b0ed7fb348eb55428a1d8e8f?fbclid=IwAR0g6Ca7mn5GkmXJuRQx8I8sTGthnONMpnelwroKB20692nQD3yBMO3BPyM
https://paste.pics/c8e120ca523126b57aaf723c7b63bc86