Who knows this function name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know does Excel provides such function to me?

I've my own-made function (f), and if my function f(10,20,30,x)=0, Does excel has a function to find out the x for me?

Thanks
Joey
 
Maybe try Goal Seek?

Suppose you have a UDF

RampUp (a,b,c,x)

where RampUp = a + b + c + x

In A1:D1, enter some numbers

Put in E1: =RampUp(A1,B1,C1,D1)

(E1 returns the sum of the numbers in A1:D1)

Now, click Tools > Goal Seek

In the dialog, input:

Set cell: E1 << your UDF cell
To value: 0 << your target value
By changing cell: D1 << your "x" in the UDF

Click OK

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
Joey Hong said:
I want to know does Excel provides such function to me?

I've my own-made function (f), and if my function f(10,20,30,x)=0, Does
Click to expand...
excel has a function to find out the x for me?
 
Back
Top