When I am working on a fairly complex spreadsheet where there are many calculated values.

For some reason this program will show me one result when I look at the formula in the fx button but when it displays the results of that formula it displays a totally different number and I can't figure out where it is getting it from. It is so frustrating to know that the computer has figured out the right result but is displaying any old number it wants.

PLEASE HELP!