Formula so that response is value
I'm not sure I follow your formulas as described, but if you're looking to
have your results display the "" character along with the value, then maybe
this example will lead you in the right direction:
Let's say cell A1 contains the value: 5.0
In B1 you put the formula: ="" & A1
B1 would display: 5.0
HTH,
Elkar
"Kaputa" wrote:
The same cell has two formulas, IF(D30,LOG(C3/F3),IF(D3<1,LOG(C3/10)). For
example, if C3 is 1.0E+06, D3 is 100, then F3 will be 1.0E+03 (due to another
formula), and the response for the first part should read 3.0. If D3 is 0,
F3 will be <10 (due to another formula), and the response should read 5.0,
not simply 5.0.
|