CELL CLEAR FORMULAS AUTOMATICALLY

%3CLINGO-SUB%20id%3D%22lingo-sub-1456764%22%20slang%3D%22es-ES%22%3ECELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456764%22%20slang%3D%22es-ES%22%3E%3CP%3EExcuse%20my%20English%20(I%20only%20speak%20Spanish).%20%3CBR%20%2F%3E%20Any%20regards.%20%3CBR%20%2F%3E%20I%20have%20a%20problem%3A%20I%20have%20a%20formula%20in%20a%20cell%2C%20but%20when%20I%20execute%20that%20formula%2C%20the%20formula%20disappears%20and%20I%20only%20have%20the%20calculation%20done.%20that%20is%2C%20the%20cell%20deletes%20the%20formula%20and%20only%20sets%20the%20result%20as%20a%20value.%20%3CBR%20%2F%3E%20Could%20you%20please%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1456764%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1456845%22%20slang%3D%22en-US%22%3ERe%3A%20CELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1456845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696606%22%20target%3D%22_blank%22%3E%40ottotevez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20a%20copy%20of%20the%20spreadsheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457042%22%20slang%3D%22es-ES%22%3ERe%3A%20CELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457042%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(excuse%20my%20English)%20%3CBR%20%2F%3E%20Yes%2C%20of%20course%2C%20with%20pleasure.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457395%22%20slang%3D%22en-US%22%3ERe%3A%20CELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696606%22%20target%3D%22_blank%22%3E%40ottotevez%3C%2FA%3EWhere%20does%20the%20problem%20occur%3F%20What%20cell(s)%20are%20involved%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457720%22%20slang%3D%22es-ES%22%3ERe%3A%20CELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457720%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22tl-input%22%3E(EXCUSE%20MY%20ENGLISH)%20The%20error%20is%20in%20cell%20%22L23%22%20(See%20imajen%20attached).%20In%20this%20cell%20is%20the%20formula.%20When%20I%20change%20the%20value%20of%20cell%20%22K23%22%20of%20a%20data%20from%20(for%20example)%20%2228%20-%2030%22%20to%20this%20other%20data%20%222%22%20(for%20example)%20cell%20%22L23%22..%20it%20puts%20the%20corresponding%20result%20%22A%22%2C%20but%20the%20formula%20disappears.%20And%20that%20happens%20to%20me%20in%20several%20cells%2C%20but%20they're%20random.%20Sometimes%20it's%20okay.%20Attached%20video.%20Thank%20you%3C%2FDIV%3E%3CDIV%20class%3D%22tl-output%22%3E(SORRY%20FOR%20MY%20ENGLISH)%20The%20error%20is%20in%20cell%20%22L23%22%20(See%20attached%20image).%20In%20this%20cell%20is%20the%20formula.%20When%20I%20change%20the%20value%20of%20cell%20%22K23%22%20from%20one%20data%20(for%20example)%20%2228%20-%2030%22%20to%20this%20other%20data%20%222%22%20(for%20example)%20cell%20%22L23%22%20..%20it%20puts%20the%20corresponding%20result%20%22A%22%2C%20but%20the%20formula%20disappears.%20And%20that%20happens%20to%20me%20in%20several%20cells%2C%20but%20they%20are%20random.%20Sometimes%20nothing%20happens.%20Attached%20video.%20Thank%20you%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457734%22%20slang%3D%22es-ES%22%3ERe%3A%20CELL%20CLEAR%20FORMULAS%20AUTOMATICALLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457734%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40mathetes%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Excuse my English (I only speak Spanish).
Regards.
I have a problem: I have a formula in a cell, but when I execute that formula, the formula disappears and I only have the calculation done. that is, the cell deletes the formula and only sets the result as a value.
Could you please help me.

5 Replies
Highlighted

@ottotevez 

 

Can you post a copy of the spreadsheet?

Highlighted

@mathetes 

 

(excuse my English)
Yes, of course, with pleasure.

Highlighted

@ottotevezWhere does the problem occur? What cell(s) are involved?

Highlighted

@mathetes 

 

(DISCULPEN MI INGLES) El error es en la celda "L23" (Ver imajen adjunto). En esta celda esta la formula. Cuando cambio el valor de la celda "K23" de un dato de (por ejemplo) "28 - 30 " a este otro dato "2" (por ejemplo) la celda "L23"..pone el resultado correspondiente "A", pero desaparece la formula. Y eso me pasa en varias celdas, pero son al azar. A veces, no pasa nada. Adjunto video. Gracias
(SORRY FOR MY ENGLISH) The error is in cell "L23" (See attached image). In this cell is the formula. When I change the value of cell "K23" from one data (for example) "28 - 30" to this other data "2" (for example) cell "L23" .. it puts the corresponding result "A", but the formula disappears. And that happens to me in several cells, but they are random. Sometimes nothing happens. Attached video. Thank you
Highlighted

@mathetes