Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I haven't used excel for a long time and can't remember how to so much at all! I need to start with a number 1, multiply it by 2, then multiply that answer by 2, multiply that answer by 2 and carry on multiplying my answers by 2 until I have done this 480 times. The answers that excel is throwing out is either as a decimal which is rounding it up and not giving a true answer, or the answer I get is 4.72237E+21 (which doesn't mean anything at all to me i'm afraid!)! Can anybody help me to get a true calculation, without rounding up etc? Any help would be much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiply a row of numbers by % | Excel Worksheet Functions | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Multiply two columns in Excel or one column by one number | New Users to Excel | |||
Formula between to numbers is true multiply | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |