Open Side Menu Go to the Top
Register
Excel / Google Sheets Help Needed Excel / Google Sheets Help Needed

07-11-2016 , 01:07 AM
Sorry if this isn't the right forum for this but I wasn't sure.

I'm trying to set up a google sheet that solves a cubic formula:

4x^3 + 6x^2 + 3x = Y

The coefficients stay the same, I just need to be able to enter a value in a cell for Y and get the x value.

$20 on paypal to whoever can do it
Excel / Google Sheets Help Needed Quote
07-11-2016 , 02:03 AM
something like:

= 4*(A1)^3+6*(A1)^2+3*(A1)

?

Where A1 is the cell you enter the info

Dunno if it gives the right answer or not, but play with parentheses and you should get there eventually

edit

oh no, i think I got it backwards. I'm using x to get y, not the other way around.

something like this won't work?

http://www.wolframalpha.com/widgets/...30c90693eafc55

If you can write out your formula in terms of Y, then you should be able to get an equation to do this. i'm way to too tired to try to figure that out though
Excel / Google Sheets Help Needed Quote
07-11-2016 , 02:38 AM
okay, try this:

= 0.5 * ((2*A1+1)^(1/3) -1)

Where A1 is Y, and the formula goes wherever you want the answer

assuming this site is right, which it seems like it might be, should give you the right numbers
Excel / Google Sheets Help Needed Quote
07-11-2016 , 03:58 AM
Yep, you nailed. Thanks a lot. PM me paypal info
Excel / Google Sheets Help Needed Quote
07-11-2016 , 07:48 AM
https://gamesdonequick.com

Hit that big green donate button and send the money to Doctors Without Borders please.

PM or post a screenshot of the donation imo
Excel / Google Sheets Help Needed Quote
07-11-2016 , 12:50 PM
Done, thanks again. It works like a charm. Cheers

Excel / Google Sheets Help Needed Quote
07-11-2016 , 12:52 PM


glad to help, and thank you for supporting an amazing charity! that's a very generous donation ^_^
Excel / Google Sheets Help Needed Quote
07-15-2016 , 11:45 PM
Nice
Excel / Google Sheets Help Needed Quote

      
m