Problem with "IF" in excel

[Triple-X]

Hello
I have a formula for the IF function and I'd like to find a solution for it , see if you have any solution for this one
In general I am trying to do this

-if the MG is between 18 and 12, the entry is "fine"
-if the MG is <12, the statement is "not allowed"

Thank you in advance.

[Macarenas]

Hello,
The MG in A1 should be some thing like this.

SI =(A1 <12;"allowed", IF(A1 <=18;"well";""))

And not the one which you are using.

-if the MG is between 18 and 12, the entry is "fine"
-if the MG is <12, the statement is "not allowed"

Try the above and it will work.

[Triple-X]

Hello
Thank you for your reply
But as you know the table if the formula are in 3 category
1 - TEST LOGIC
2- value_if_true
3- value if false
now you just answered my 3rd point, I guess, on which the value false if I'd like to have it on 3 stages. If you have any solution for the remaining then please do post back.

[Macarenas]

Hello
Ok, you can try this out, see if it works with you. It work fine with me.

= IF (
logical test: A1 <12;
value_if_true: "not allowed";
value_if_false: IF (A1 <= 18; "fairly ";"")

= IF (
logical test: A1 <= 18;
value_if_true: "fairly well";
value_if_false: ""

Hope you will solve your problem. And if any more queries then do post back.

[Triple-X]

Hello

= IF (
logical test: A1 <12;
value_if_true: "not allowed";
value_if_false: IF (A1 <= 18; "fairly ";"")

Thanks for you answer, I think this will work for me.
It has given me a positive reply, but I do not understand what is happening in the back ground. If you could explain me in more details it will be appreciated.

[Glenny]

Hello
Instead of the following formula to use

SI =(A1 <12;"allowed", IF(A1 <=18;"well";""))

You can use this formula, it would be much more effective than the earlier one.

= IF (A1 <12,"not allowed", IF (A1 <= 18,"fairly well",""))

Hope you will try this one.