Different results in Formulas??

[RudeBoy]

I have noticed today in my excel sheet that a few formulas are giving differant results for the same FORMULAS. Only difference is they are entered in different cells or are calling data from a different folder within the spread-sheet.. ??

 

[RudeBoy]

It is still happening as I work in my Exel Speadsheet so now it's freaking me out that all the formulas I enter will be reporting WRONG values?? Hmm is there some cache I need to clear or is it a memory issue?? HELPppppppppppppppppppp

 

[Robert Mika]

It is still happening as I work in my Exel Speadsheet so now it's freaking me out that all the formulas I enter will be reporting WRONG values?? Hmm is there some cache I need to clear or is it a memory issue?? HELPppppppppppppppppppp

Post your formula +screenshot.

 

[RudeBoy]

TEAM EVENT MONEY NEEDED = $8,272.00
Formula is ='LV Breakdown W2012-2013'!C28

This is from LV Breakdown W2012-2013'!C28 the total 8,268 is the cell
Team Event Divisible by 4 $8,268.00
Formula is=C27-MOD(C27,4)

How do I send screen shots?

 

[Robert Mika]

TEAM EVENT MONEY NEEDED = $8,272.00
Formula is ='LV Breakdown W2012-2013'!C28

This is from LV Breakdown W2012-2013'!C28 the total 8,268 is the cell
Team Event Divisible by 4 $8,268.00
Formula is=C27-MOD(C27,4)

How do I send screen shots?

I asked for screenshot to see your live example but you can as well post data(pleae see my signature on how to do it) or post your workbook using external site(box,googlemail,dropbox)

 

[RudeBoy]

http://www.rudeboy.info/Rude-Live/images/PIC1.jpg

http://www.rudeboy.info/Rude-Live/images/PIC2.jpg

http://www.rudeboy.info/Rude-Live/images/PIC3.jpg

http://www.rudeboy.info/Rude-Live/images/PIC4.jpg

 

[RudeBoy]

I read a article on clearing cahe and I did this and NOW all my formulas are okay now I did this:

Ctrl+Alt+Shift+F9

Now my question is what the heck is that?? Does it clear cache or something.. Please advise.. thanks

 

[RudeBoy]

Very Weird when I hit F9 I can see the correct Value it FLASHES and then puts the wrong value back in???

What is that??

Anyone had this same issue with a large excel sheet with thousands of formulas etc going on?

 

[RudeBoy]

Looks like I am getting Closer.. I read that I need to change the Calculation settings in EXCEL? But I am not sure how to change these and what values to put in..?? HELPpppppppp

I guess you go into TOOLS then you click Options and then you are in there.. Iterations is set to 100 Calculation set to Automatic?? Thanks for your help..

 

[RudeBoy]

I went into one of the sheets in question I went into Tools - Options and then clicked Calc Sheet and it fixed my formulas that were reporting incorrectly??

Have I reached some limit within Excel? Helppppppppppp