Prev: How do I find the minimum value in a range while ignoring zeros?
Next: Sum Indirect
From: Mary S Mary on 6 Apr 2010 03:55

I need an excel formula which claculates 'between' 95% and 100% i.e.

If( O2= between 95% and 100%, 1 x 2, 2 x 3)

I need nested IF functions,
From: Bob Phillips on 6 Apr 2010 03:58
Try

=IF(AND(Q2>=95%,Q2<=100%),2,6)

--

HTH

Bob

"Mary S" <Mary S(a)discussions.microsoft.com> wrote in message
news:11515387-1991-470B-99CC-9B858BAC35DF(a)microsoft.com...
>
> I need an excel formula which claculates 'between' 95% and 100% i.e.
>
> If( O2= between 95% and 100%, 1 x 2, 2 x 3)
>
> I need nested IF functions,


From: Mike H on 6 Apr 2010 04:09
Mary,

> I need nested IF functions,

You could but using AND is better. Note that 0.95 and 1 equate to 95% and 100%

=IF(AND(O2>=0.95,O2<=1),1*2,2*3)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mary S" wrote:

>
> I need an excel formula which claculates 'between' 95% and 100% i.e.
>
> If( O2= between 95% and 100%, 1 x 2, 2 x 3)
>
> I need nested IF functions,
From: Joe User on 6 Apr 2010 11:15
"Mary S" <Mary S(a)discussions.microsoft.com> wrote:
> I need nested IF functions

Not for this, you don't. Is there more to it?


> I need an excel formula which claculates 'between' 95% and 100% i.e.
> If( O2= between 95% and 100%, 1 x 2, 2 x 3)

Do you mean the strings "1x2" and "2x3", as in "one by two" and "two by
three"? Otherwise, why would you multiply 2 times 1?

And do you truly mean that O2 contains percentages? If so, are they truly
in the form 95% or 0.95, or are they in some other form (e.g. 95 or even
"95%")?

Making lots of assumptions, try:

=if(and(95%<=O2,O2<=100%), "1x2", "2x3")

From: Joe User on 6 Apr 2010 11:48
I wrote:
> "Mary S" <Mary S(a)discussions.microsoft.com> wrote:
>> I need nested IF functions
>
> Not for this, you don't. Is there more to it?

I meant to add.... If your class assignment requires nested IF functions,
then:

=if(O2>=95%, if(O2<=100%, "1x2", "2x3"), "2x3")

But you can see that in this case, that is not as tidy as using the AND
function, which might be the purpose of the "nested IF" assignment.


----- original message -----

"Joe User" <joeu2004> wrote in message
news:eSNNAwZ1KHA.4560(a)TK2MSFTNGP02.phx.gbl...
> "Mary S" <Mary S(a)discussions.microsoft.com> wrote:
>> I need nested IF functions
>
> Not for this, you don't. Is there more to it?
>
>
>> I need an excel formula which claculates 'between' 95% and 100% i.e.
>> If( O2= between 95% and 100%, 1 x 2, 2 x 3)
>
> Do you mean the strings "1x2" and "2x3", as in "one by two" and "two by
> three"? Otherwise, why would you multiply 2 times 1?
>
> And do you truly mean that O2 contains percentages? If so, are they truly
> in the form 95% or 0.95, or are they in some other form (e.g. 95 or even
> "95%")?
>
> Making lots of assumptions, try:
>
> =if(and(95%<=O2,O2<=100%), "1x2", "2x3")

 | 
Pages: 1
Prev: How do I find the minimum value in a range while ignoring zeros?
Next: Sum Indirect