Help with formulas for scientific notation

Copper Contributor

I am learning scientific notation and I am Excel dumb. I need to learn how to create formulas. I am stuck. y=3x^+6x/2x

if x=5. I need to write the formula in excel for that equation, having a hard time.

3 Replies

@tllaney 

Please double-check the equation. It makes little sense as you posted it...

y=3x^2+6x/2x. It’s how the text book has it. So I need to learn how to turn that into a formula where x=5, I need to write the formula for cell Ya

@tllaney 

The main point is that you always have to indicate multiplication explicitly by using the * operator. It cannot be implicit as in the math expression 6x. You must use 6*x.

 

Enter the value 5 (for x) in a cell, say in A1.

In another cell, say B1, enter the following formula for y:

 

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

 

or, since 6x/2x = 3:

 

=3*A1^2+3