Excel many conditions forumula

**suzanna12** · 06-05-2012, 08:23 AM

Good afternoon,

It´s my first time posting so I will try to be clear

I need a forumula that tell me :
if the value in C2 is bigger than the cell H2+20%, I want the word "RISK"
if the value in C2 is smaller than the value in cell H2, I want the word "SAFE"
if the value is lower than H2+20%, I want the word "RULE 20%"

I´ve done this but it doesn´t work
=IF(LEN(C2)>(H2+(H2*0,2));"RISK",IF(LEN(C2)>(H2+(H2*0,2)),"SAFE"),IF(LEN(C2)<(H2+(H2*0,2);"20%RULE"))

Can anybody help me please ? I´m getting lost in trying things with no sense...

Cheers,
Suzzi

**arlu1201** · 06-05-2012, 08:25 AM

Remove the "Len" from your formula. Len is used to find the length of the characters in the cell. It wont check the value of the cell.

**NBVC** · 06-05-2012, 08:27 AM

Try

=IF(C2<H2,"SAFE",IF(C2<H2*1.20,"RULE 20%","RISK"))

**suzanna12** · 06-05-2012, 08:42 AM

hello again,

Thanks for your quick answers ! I tried but it still doesn´t work

**Cutter** · 06-05-2012, 08:50 AM

Did you adjust the formula to your regional settings?

Maybe you need: =IF(C2<H2;"SAFE";IF(C2<H2*1,20;"RULE 20%";"RISK"))

**suzanna12** · 06-05-2012, 08:52 AM

Hey, thanks again.

Unafortunely, I have an #¿NOMBRE? error with the last option...

**NBVC** · 06-05-2012, 09:10 AM

Should you replace the IF with your language's translation of IF?

=SI(C2<H2;"SAFE";SI(C2<H2*1,20;"RULE 20%";"RISK"))

**suzanna12** · 06-05-2012, 09:15 AM

hey,

I don´t have to replace as I have an english version

**NBVC** · 06-05-2012, 09:17 AM

and you are getting #¿NOMBRE? error ? That's strange.

Then maybe try retyping all the words with quotes again (incl. quotes). Sometimes the translation might mess up.