Highlighted
New Contributor

# Help with formulas for scientific notation

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
Highlighted

# Re: Help with formulas for scientific notation

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

Highlighted

# RE: Help with formulas for scientific notation

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
Highlighted

# RE: Help with formulas for scientific notation

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