| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
partial calculation displays in formula
If I enter a formula - ie - =2*2*2 it changes to show a partial calculation.
It displays 4*2. I am sure I have accidently clicked something, but I cannot figure out what. Any ideas? -- Sandy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
partial calculation displays in formula
What happens with 4*3*2 ?
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Sandy" wrote in message ... If I enter a formula - ie - =2*2*2 it changes to show a partial calculation. It displays 4*2. I am sure I have accidently clicked something, but I cannot figure out what. Any ideas? -- Sandy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
partial calculation displays in formula
That was just an example - the first set always shows as calculated-in your
example it would be 12*2 -- Sandy "Bernard Liengme" wrote: What happens with 4*3*2 ? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Sandy" wrote in message ... If I enter a formula - ie - =2*2*2 it changes to show a partial calculation. It displays 4*2. I am sure I have accidently clicked something, but I cannot figure out what. Any ideas? -- Sandy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculation of partial shipments | Excel Worksheet Functions | |||
| Formula to calculate partial payments | Excel Worksheet Functions | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
