Formula so that response is value
 

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.

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.

Formula so that response is value
 

IF(D30,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
--
paul
remove nospam for email addy!



"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.

Formula so that response is value
 

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Kaputa" wrote in message
...
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.

Formula so that response is value
 

yes i noticed that the conditions werent exclusive but thought the formula
was "illustrative" only
--
paul
remove nospam for email addy!



"RagDyer" wrote:

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Kaputa" wrote in message
...
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.