Perfoming calculations on answers from pervious calculations

K

Karl Everett

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
 
F

Frank Kabel

Hi
maybe 'Tools - Options - Calculation' and check 'Automatic calculation
'
 
Top