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