About Us

renzouken

Hi! Can anyone help me how to properly apply this function

=(2/3)*(B2)*(B2^(-2/3)), where B2=-1

I tried this =((2/3)*(B2))*(SIGN(B2)^(-2/3)), but not working

Thanks in advance! ! !

wickedchew

Quote:

Originally Posted by renzouken

Hi! Can anyone help me how to properly apply this function

=(2/3)*(B2)*(B2^(-2/3)), where B2=-1

I tried this =((2/3)*(B2))*(SIGN(B2)^(-2/3)), but not working

Thanks in advance! ! !

=((2/3)*(B2))*(ABS(B2)^(-2/3))

renzouken

Quote:

Originally Posted by wickedchew

=((2/3)*(B2))*(ABS(B2)^(-2/3))

Its working ^__^

dude thanks a lot! ! ! ! ! ! !

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show fraction as fraction even if answer is 1	Vin Sukhadia	Charts and Charting in Excel	1	December 2nd 09 07:51 PM
Text fraction to fraction format	brownti via OfficeKB.com	Excel Worksheet Functions	1	February 1st 08 02:38 PM
How do I change fraction to fraction characters?	cmcqueary2806	Excel Worksheet Functions	1	November 2nd 06 09:58 PM
Excel 2003 SP2 computes the power of a negative number wrong.	Giovanni Ciriani	Excel Worksheet Functions	26	October 27th 06 02:43 AM
Change color to red when fraction is negative	clive1950	Excel Worksheet Functions	1	August 25th 05 03:04 AM

Menu

About Us