How do I use 'between' 95% and 100% for a nested IF function?
 

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,

How do I use 'between' 95% and 100% for a nested IF function?
 

Try

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

--

HTH

Bob

"Mary S" <Mary wrote in message
...

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,

How do I use 'between' 95% and 100% for a nested IF function?
 

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,

How do I use 'between' 95% and 100% for a nested IF function?
 

"Mary S" <Mary 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")

How do I use 'between' 95% and 100% for a nested IF function?
 

I wrote:
"Mary S" <Mary 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
...
"Mary S" <Mary 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")