Formulas Disapearing

[LuisFernandes22]

Dears, I have done a workbook with about 20 pages, with several names and formulas, most of them "IF" like.
After close and open the file/workbook, I notice several formulas absent, from the cell, or printed in the cell, one of 2 possible results. NAD ADQ. Anyone knows if there are a limit in number of formulas, in a cell, or even in a workbook? If anyone could help, I can upload the workbook, just to be analyzed, and eventually tell me what am I doing wrongly. Thanks to everyone. Luis

 

[thisoldman]

I feel bad that you have all this work. Do you still have formulas disappearing?

 

[LuisFernandes22]

Hi thisoldman, yes, I am just replacing formulas, with the solution you have proposed, and each time I fill a sheet, with new formulas, and evaluate that sheet, (removing X, in previous page, and fill the new with x), I will take a look in last page, (avalfinal), since I should see a new column being filed with x. There are always some cells empty, usually without a formula. The strange thing is that I have different behaviors, in some formulas I find, one of possible results, on other ones, the formula is simple missing. I will keep redoing all formulas, and then, I will start to remove pages/sheets in the middle, like "soma", just to see and learn about changes in behavior.
Thanks luis