If formula

[Veronica_sky]

Can i know why this formula doesnt work?

=IF(10%>$F$9<30%,$G$4,IF($F$9>30%,$H$4," "))

Where by i wan to show if F9>10% but Less den 30% = Cell G4 (1 mark) and
if F9> 30% - Cell H4 (2marks)
** my cell F9 was in percentage dy..

Thanks a lot

 

[CWatts]

You have the right idea but your syntax is off a little.

=IF(10%>$F$9<30%,$G$4,IF($F$9>30%,$H$4," "))

You can't test multiple conditions like you did above, To accomplish that you'd need to merge those conditions with an AND statement:

=IF(AND(10%>$F$9,$F$9<30%),$G$4,IF($F$9>30%,$H$4," "))

 

[Veronica_sky]

Dear CWatts,
Okies.. i got it.. Really thanks a lot.. i did try to insert and just now, but i did place it wrongly as well.. now i know what's my mistakes..
Thanks and appreciate it

 

[Aladin Akyurek]

It's better to avoid returning a space character. Also, the formula does not cover the case of being equal to 30%...

=IF(AND(F9 > 10%, F9 < 30%), $G$4, IF(F9 >= 30%, $H$4, ""))

Note the difference between " " and "".