brian873 Posted January 10, 2008 Share Posted January 10, 2008 Hi I would like to know how to use scientific notation in excel.Can anyone help?I'll use the following as an example.5.42 × 103 = 5,420Thanksbrian Link to comment Share on other sites More sharing options...
skylark53 Posted January 11, 2008 Share Posted January 11, 2008 Hmm, confused. There's no difficulty entering this as either text or numbers...Do you mean you want to enter numbers into columns A and B and have the result appear in col C? If so, then in Col C you type "=A*B" (without the quotes). Link to comment Share on other sites More sharing options...
brian873 Posted January 11, 2008 Author Share Posted January 11, 2008 Hi skylark53, thanks for the reply.Sorry I copy and pasted he last post and the format was lost. So...5.42 × 103 = 5,420 should have been5.42 x 10 (to the power of) 3 = 5,420Any ideas? Link to comment Share on other sites More sharing options...
skylark53 Posted January 11, 2008 Share Posted January 11, 2008 Well, then it's "=a*b**3"Or, if what you need is a superscript 3, then highlight the 3, go into format cells, font, then choose superscript. Link to comment Share on other sites More sharing options...
brian873 Posted January 11, 2008 Author Share Posted January 11, 2008 Thanks again for the reply skylark53 but I think we are talking about two different things here.It is not the format I am concerned about it is how to perform the calculation. Link to comment Share on other sites More sharing options...
skylark53 Posted January 11, 2008 Share Posted January 11, 2008 It's "=a*b**3". It's very similar to ordinary algebraic (ro rather, Fortran) notation.Scientists are from Mercury... ;}} Link to comment Share on other sites More sharing options...
brian873 Posted January 11, 2008 Author Share Posted January 11, 2008 Sorry skylark53 you are loosing me here. What I would use is...5.42 x 10 x 10 x 1- = 5420 (10 to the power of 3) Why do you use use ** twice ? Link to comment Share on other sites More sharing options...
skylark53 Posted January 11, 2008 Share Posted January 11, 2008 Hang in there! ** means 'to the power of'. Putting "=a*b**3" into column C makes Excel do the calculation (contents of A) times (contents of B to the power 3) and stick the result in column C. Try it...I have to go about in 10 minutes but if you like, send me an email later and we can continue to talk lke aliens! ;}} Link to comment Share on other sites More sharing options...
brian873 Posted January 11, 2008 Author Share Posted January 11, 2008 Excel 2007 will not let me enter two ** Maybe we can continue this on monday !Thanks for helping out. Link to comment Share on other sites More sharing options...
skylark53 Posted January 11, 2008 Share Posted January 11, 2008 Sorry; try "^" instead of **And don't forget the cell numbers, i.e. "=(a14*b14)^3 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now