Numbers change when they shouldnt?

%3CLINGO-SUB%20id%3D%22lingo-sub-3220547%22%20slang%3D%22en-US%22%3ENumbers%20change%20when%20they%20shouldnt%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220547%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3E%26nbsp%3BSo%20I'm%20having%20this%20issue%20when%20I'm%20using%20Excel.%20I've%20table%20which%20contains%20some%20formula%20answers%2C%20but%20whenever%20I%20press%20anything%20like%20anything%20at%20all%20the%20answers%20change%3F%20For%20example%2C%20whenever%20I%20press%20save%20or%20press%20on%20a%20cell%20that%20I%20haven't%20referred%20to%20at%20all%20the%20answers%20completely%20change.%20They%20don't%20round%20up%20or%20get%20simplified%20or%20anything%2C%20they%20just%20change%20to%20a%20different%20answer.%20Anyone%20know%20what's%20up%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3220547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220792%22%20slang%3D%22en-US%22%3ERe%3A%20Numbers%20change%20when%20they%20shouldnt%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220792%22%20slang%3D%22en-US%22%3EThis%20sounds%20like%20you%20have%20a%20%22Volatile%22%20function%20which%20is%20a%20fancy%20way%20of%20saying%20a%20function%20that%20always%20gets%20recalculated.%20And%20in%20your%20case%20it%20sounds%20like%20you%20have%20the%20RAND()%20function%20or%20one%20of%20its%20cousins%20on%20the%20sheet%20but%20it%20could%20be%20a%20UDF%20(user%20defined%20function%20like%20a%20macro).%20Without%20looking%20at%20the%20sheet%20I%20suggest%20you%20start%20by%20doing%20a%20FIND%20for%20%22RAND%22%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey,

 So I'm having this issue when I'm using Excel. I've table which contains some formula answers, but whenever I press anything like anything at all the answers change? For example, whenever I press save or press on a cell that I haven't referred to at all the answers completely change. They don't round up or get simplified or anything, they just change to a different answer. Anyone know what's up with this?

1 Reply
This sounds like you have a "Volatile" function which is a fancy way of saying a function that always gets recalculated. And in your case it sounds like you have the RAND() function or one of its cousins on the sheet but it could be a UDF (user defined function like a macro). Without looking at the sheet I suggest you start by doing a FIND for "RAND"