question about if function

**orbachkl** · 02-04-2012, 04:58 PM

I try to use the if function in this case:
I want that if H2>89 to write "A" and if not to write "B"
what the excel do actually write: =IF(H2>89,"A","B")
instead of turn it to "B" (because it's false)
what am I do wrong?

and what I need to write in this case:if H2>89 -> write "A",
if H2>70 and H2<88 -> write "B"
if H2<70 -> wirte "F"

**Fotis1991** · 02-04-2012, 05:24 PM

Hi and welcome to the forum.

Try this.

=IF(H2>89;"A";IF(H2<70;"F";IF(AND(H2>=70;H2<=89);"B")))

If you have to do it, then change the semi-colons to gomma!

Hope to helps you.

**Special-K** · 02-04-2012, 05:50 PM

Here's a better quicker way

IF(H2>89,"A",IF(H2>70,"B","F"))

**orbachkl** · 02-05-2012, 06:45 AM

I tried to do what you say but it still do me a problem with the formula.
Instead of writing the solution to the fomula, it wrote the formula itself on the box

**Fotis1991** · 02-05-2012, 08:31 AM

Hi

Take a look to the example.

Includes both of the solutions.

**Palmetto** · 02-05-2012, 08:36 AM

=lookup(H2,{0,71,89},{"F","B","A"})

A more appropriate title for your thread would be: Match text to number value or Look up number and return matching text