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

[Mary S]

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,

 

[Bob Phillips]

Try

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

 

[Mike H]

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.

 

[Joe User]

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

 

[Joe User]

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