Formula so that response is >value

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.

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

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
--
paul
remove nospam for email addy!



"Kaputa" wrote:

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

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" <Kaputa@discussions.microsoft.com> wrote in message
news:C4BBE123-D2F8-4168-B86B-F1DF740185A3@microsoft.com...
> 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.
>
>

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" <Kaputa@discussions.microsoft.com> wrote in message
> news:C4BBE123-D2F8-4168-B86B-F1DF740185A3@microsoft.com...
> > 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.
> >
> >
>
>