software

A discusion group entry on 4/20 contained the following formula:

q = -(b sgn(b)*sqrt(b^2-4a*c))*0.5

in relation to the quadratic function.
What is sgn? Does it appear in Excel 2000?
Thanks everyone.
CJ

Hi CJ,

sgn is a VB math method that returns -1,0 or 1.
sgn(b) = -1 if blt;0, 0 if b=0 and 1 if bgt;0.

I'm pretty sure it would be in all versions of Excel

The Worksheet function equivalent is called SIGN.

Ken JohnsonThank you, SIGN is: quot;Determines the sign of a number. Returns 1 if the
number is positive, zero (0) if the number is 0, and -1 if the number is
negative.quot; quoted from Excel 2000.

Thanks again
quot;Ken Johnsonquot; wrote:

gt; Hi CJ,
gt;
gt; sgn is a VB math method that returns -1,0 or 1.
gt; sgn(b) = -1 if blt;0, 0 if b=0 and 1 if bgt;0.
gt;
gt; I'm pretty sure it would be in all versions of Excel
gt;
gt; The Worksheet function equivalent is called SIGN.
gt;
gt; Ken Johnson
gt;
gt;

You're welcome CJ

Ken Johnson