ExcelBanter - partial calculation displays in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - partial calculation displays in formula (https://www.excelbanter.com/excel-discussion-misc-queries/162908-partial-calculation-displays-formula.html)

Sandy

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

Bernard Liengme

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

Sandy

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

All times are GMT +1. The time now is 05:40 AM.