Help with formulas for scientific notation

%3CLINGO-SUB%20id%3D%22lingo-sub-1684448%22%20slang%3D%22en-US%22%3EHelp%20with%20formulas%20for%20scientific%20notation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1684448%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20learning%20scientific%20notation%20and%20I%20am%20Excel%20dumb.%20I%20need%20to%20learn%20how%20to%20create%20formulas.%20I%20am%20stuck.%20y%3D3x%5E%2B6x%2F2x%3C%2FP%3E%3CP%3Eif%20x%3D5.%20I%20need%20to%20write%20the%20formula%20in%20excel%20for%20that%20equation%2C%20having%20a%20hard%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1684448%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1684582%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formulas%20for%20scientific%20notation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1684582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798987%22%20target%3D%22_blank%22%3E%40tllaney%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20double-check%20the%20equation.%20It%20makes%20little%20sense%20as%20you%20posted%20it...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@tllaney 

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

Highlighted
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

@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