Example:
Start with $O$8 filled with 6
A1 =$O$8>=5 displaying TRUE
B1: Put into B1 = FORMULATETEXT(A1) It displays =$O$8>=5. I'm not sure what to call this information except "string"...
C1: COPY B1. PASTE SPECIAL as VALUE into C1 It displays the same as B1 =$O$8>=5. I'm not sure what to call this information except "string"...
D1: Put into D1: =RIGHT(C1,LEN(C1)-1). It displays $O$8>=5. But the string that is displayed isn't editable because the cell contains a formula.
E1: COPY D1. PASTE SPECIAL as VALUE into E1. This is an editable string. Edit it to read =$O$8>=7
F1: Enter: =Concatenate("=",D1) It displays =$O8>=7. I'm not sure what to call this information except something like "formula string"
G1: I want to put the formula displayed in F1 into G1 such that it is executed. It should display FALSE.
How? Perhaps with VBA?
Thank you!