Is it possible to have a formula ignore the tilde and still give me a result from the formula?
ex:
Cell A1 contains the value 2
Cell B1 contains the ~4
Cell C1 contains the formula =A1+B1
I am using the ~4 to indicate that it is 'an estimate' or an 'assumption' of what I think the number should be.
someone told me that the ~ can be used for this purpose, but of course, I cannot get the formula to give me a result- all I get is #Value.
Any help is greatly appreciated.
ex:
Cell A1 contains the value 2
Cell B1 contains the ~4
Cell C1 contains the formula =A1+B1
I am using the ~4 to indicate that it is 'an estimate' or an 'assumption' of what I think the number should be.
someone told me that the ~ can be used for this purpose, but of course, I cannot get the formula to give me a result- all I get is #Value.
Any help is greatly appreciated.