You need a value in B1 before Goal Seek will work. Right now Goal Seek
treats the empty space as a 0 value. Goal Seek is meant to change the value
currently in a cell, not propose an initial value. If the cell has no value,
Goal Seek interprets that as a 0 value.
--
Brevity is the soul of wit.


"tikchye_oldLearner57" wrote:

hi community

With the given parameter (below), I tried using Goal Seek to find the Cost,
but I got zero value, can Goal Seek solve this ?

example:

A B C D
1 Cost

2 Sale 10000

3 Profit 5%

I am curious and any enlightenment would be much appreciated :)

thanks everybody :)

--
oldLearner57