EXCEL FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-1117301%22%20slang%3D%22en-US%22%3EEXCEL%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117301%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20and%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20a%20formula%20where%20using%20an%20IF%20statement%20if%20in%20my%20case%20cell%20E39%20equals%20No%20then%20cell%20P13%20is%20set%20at%20Zero%20and%20is%20locked%20for%20editing%20and%20if%20E39%20equals%20Yes%20the%20P13%20is%20not%20locked%20and%20a%20figure%20can%20be%20manually%20placed%20in%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20doing%20a%20Macro%20for%20the%20above%20as%20well%20but%20no%20luck%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20guidance%20you%20can%20give%20will%20be%20greatly%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1117301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

One and all

 

I am trying to set a formula where using an IF statement if in my case cell E39 equals No then cell P13 is set at Zero and is locked for editing and if E39 equals Yes the P13 is not locked and a figure can be manually placed in the cell.

 

Tried doing a Macro for the above as well but no luck

 

Any guidance you can give will be greatly appreciated

 

.

 

 

0 Replies