Perfoming calculations on answers from pervious calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I have a user who is trying to perform a simple divide to a number of data
fields, however this data appears in the field due to a larger calculateion.
When she tries to put in the devide she get the orriginal calculation in the
cell rather than just the answer from it. I've been told its just a setting
but i cant find it!!! Any ideas anyone??

Cheers
 
Hi
maybe 'Tools - Options - Calculation' and check 'Automatic calculation
'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculator Answer Doesn't Match Excel Answer 3
Unable to change field settings in calculated field in a pivot tab 1
Pivot Table calculated item 4
Pivot table calculate field 3
Calculated field in Pivot Table 2
Excel Excel Formula to calculate economy of a bowler (Cricket) 2
calculating values across multiple fields for DSTDEV 3
Pivot table for calculations 1

Back
Top