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

  • Thread starter Thread starter Mary S
  • Start date Start date
M

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,
 
Mary,
I need nested IF functions,
Click to expand...

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 said:
I need nested IF functions
Click to expand...

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)
Click to expand...

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")
 
I said:
Not for this, you don't. Is there more to it?
Click to expand...

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