goal seek

[tikchye_oldLearner57]

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

 

[Carim]

Hi,

Believe you need in cell B1 :
=B2*(1-B3)
Then you can play with goal seek ...

HTH
Cheer
Carim

 

[Dave F]

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.

 

[Dave O]

Another consideration: what profit calculation are you performing?
Gross margin is a different calculation than markup.

Gross margin = (Price - Cost) / Price
Markup = (Price - Cost) / Cost