MJDercks
asked on
Formula lost from cell and only value retained Excel 2010
I have at least to cells, formated as currency , locked and hidden. Each has a formula that produces a correct value. On save and re-load the formula is gone and only the value (still the originally correct one) is in the cell. Any ideas on what causes this and how to prevent?
cell 1 formula: =ROUND(IF(DHSConversionRat eOKed,MAX( (dhsEWBudg etCapConve rsion),(Da ilyNFRate* 365/12)-VL OOKUP(IF(I SBLANK(CLS erviceDate ),TODAY(), CLServiceD ate),Medic aidMaintRe q,2,TRUE)) ,MIN((dhsE WBudgetCap Conversion ),(DailyNF Rate*365/1 2)-VLOOKUP (IF(ISBLAN K(CLServic eDate),TOD AY(),CLSer viceDate), MedicaidMa intReq,2,T RUE))),2)
Cell 2 Formula: =ROUND(xlsProposedCLRateAd justedforD aysAbsent, 2)
Precedents are ok; These had been control sources for form text boxes, though other cells that are control sources and had formulas did not loose their formulas
cell 1 formula: =ROUND(IF(DHSConversionRat
Cell 2 Formula: =ROUND(xlsProposedCLRateAd
Precedents are ok; These had been control sources for form text boxes, though other cells that are control sources and had formulas did not loose their formulas
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER