Formula so that response is >value

[Guest]

The same cell has two formulas, IF(D3>0,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.

 

[Guest]

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

 

[Guest]

IF(D3>0,LOG(C3/F3),IF(D3<1,&">"LOG(C3/10)).Is this what you mean,if d3<1 then
play >LOG(c3/10).I hope i have the syntax right

 

[RagDyer]

You have to re-think your formula!

It will *always* perform the *first* calculation:
LOG(C3/F3)

Because ... even if D3 is <1 (0.05), it's *still* >0 !
SO, the first argument is True (>0), and the first calculation will execute,
and the formula *stops* calculating.
It never gets to even evaluate the second argument, much less calculate it.

 

[Guest]

yes i noticed that the conditions werent exclusive but thought the formula
was "illustrative" only