Nest IF/THEN functions

[CB1984]

I have averaged out some data and am trying to create a formula to give me an answer from that but it is only telling me "True" or "False"
For example: Box E7 shows the data averaged to 83.74%. I am trying to make B18 tell me if the data is less than 85.00% then it equals "Did Not Meet" and if the data is between 85.00% and 90.00% then it equals "Meet"... ect.
Can anyone help me with this?

[protonLeah]

Unfortunately you didn't post the formula for us to look at.....

[ConneXionLost]

Do you mean like this?

Please Login or Register  to view this content.

Cheers,

[ConneXionLost]

Is this a duplicate post?

[CB1984]

Sorry. This is what I'm using when I am only receiving the True or False answers:


=IF(E7=">85.00%",Then(E7=Did Not Meet,))=IF(E7=">90.00% and <85.00%",Then(E7=Meets))=IF(E7=">90.00% and <95.00%",Then(E7=Exceeds))

[protonLeah]

Please Login or Register  to view this content.

OK. That formula has several problems:
1. In Excel IF/THEN formulas, the words "Then" and "Else" are not used. For examplen the formula:

Please Login or Register  to view this content.

Is read If x (is true) then put y in the cell, else (since x is false) put z in the cell. Here notice that the commas take the place of the words "then" and "else".
2. You are trying to use a formula to test the value of the contents of a cell and then replace the contents the contents of the tested cell. You cannot do that. A cell can only have a formula or a value. Nor can you use a formula in one cell to manipulate the contents of another cell.
In the example, you seem to be trying to replace a percentage value in E7 with a phrase using a formula in E7. The formula in E7 can only test the contents of other cells, not itself.

3.Since you did not post a workbook, I don't know what is in cell E7 to begin with, whether it is a calculated number or a text string. Because your test condition is: ">85.00%" indicating a text string with the actual characters between the quotes, Excel would expect to see exactly that text string.

However, I think you have made some kind of calculation which should result in a number between 0 and 100 percent (??)

Now, look at your first condition, namely: E7=">85.00%"
This seems to be saying that you want to fail any test that exceeds 85% (?) Do you really want to do that?

Then you have: E7=">90.00% and <85.00%"
which says that the acceptable range is greater than 90% but less than 85%, Uh oh

Finally, you have: E7=">90.00% and <95.00%"
which says that a value greater than 90% and less than 95% exceeds the standard.

Normally, you would have:
Fail @ <85%
Meets >85% and <95%
Exceeds > 95%

So, given some NUMERICAL value in E7 you can have a formula such as:

Please Login or Register  to view this content.

Read as, If E7 is less than 85 then "fails", ELSEIF E7 is greater than 95 it exceeds the standard, ELSE it meets the standard. Notice that the FALSE ( Else) clause of the original IF statement is itself another IF statement and therefore it is nested

[CB1984]

Thank you so much for your help. I will input it using this information and if I can get it to work I will go ahead and change my issue to solved.

[CB1984]

My issue is solved. Thanks for your help.