Function

S

Scott (TSS-11)

I am using the IF statement and looking to return the following:

IF A2 >= to 98.5% returns Exceeds
IF A2 = to 100% returns Far Exceed

Each time I have 100% I am getting a return value of Exceeds, which I attribute to it equaling the initial IF statement.
 
M

Michael Malinsky

You probably want to use

=IF(AND(A2>=98.5%,A2<100%),"Exceeds",IF(A2=100%,"Far Exceeds",""))

First we determine if A2 is between 98.5% and 100%, if it is, it returns
Exceeds, if not, we test if A2 equals 100%. If it is, it returns Far
Exceeds. If none of these conditions is met, the an empty string ("") is
returned.

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

Scott (TSS-11) said:
I am using the IF statement and looking to return the following:

IF A2 >= to 98.5% returns Exceeds
IF A2 = to 100% returns Far Exceed

Each time I have 100% I am getting a return value of Exceeds, which I
Click to expand...
attribute to it equaling the initial IF statement.
 
P

Peo Sjoblom

It's because both conditions are true, you have to do something like

=IF(AND(A2>=98.5%,A2<100%),"Exceeds",IF(A2=100%,"Far Exceeds","Not good
enough"))

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom


Scott (TSS-11) said:
I am using the IF statement and looking to return the following:

IF A2 >= to 98.5% returns Exceeds
IF A2 = to 100% returns Far Exceed

Each time I have 100% I am getting a return value of Exceeds, which I
Click to expand...
attribute to it equaling the initial IF statement.
 
R

Ron Rosenfeld

I am using the IF statement and looking to return the following:

IF A2 >= to 98.5% returns Exceeds
IF A2 = to 100% returns Far Exceed

Each time I have 100% I am getting a return value of Exceeds, which I attribute to it equaling the initial IF statement.
Click to expand...

Test first for 100%.

=IF(A1>=100%,"Far Exceeds",IF(A1>=98.5%,"exceeds",A1))


--ron
 
Top