Hi ,
One solution has already been posted , provided you want 10 and 3 to be text values ; if not , you will have to change the posted solution ; I'll just add some explanation.
Writing a correct formula is just a matter of expressing the logic in any language ; for example , if we write down your formula in simple English , we would say :
If F3 contains "N" ( or F3 is equal to "N" ) , this cell ( since you are entering the formula in H3 ) should get the value 10 ; if F3 contains "Y" , this cell should get the value 3.
The syntax of the IF statement is :
=IF(condition to be checked,what is to be done if condition is TRUE, what is to be done if condition is FALSE)
Here the condition to be checked is : F3="N" ; you can also use F3="Y".
what is to be done if condition is TRUE is : 10
what is to be done if condition is FALSE is : 3
Hence , one form of the formula would be :
=IF(F3="N",10,3)
Another form could be :
=IF(F3="Y",3,10)
In both the above cases , we are assuming that if F3 does not contain "N" , it will contain "Y" and vice-versa. Try both the above formulae by entering any character other than "Y" and "N" in F3.
If you specifically want to check for only "Y" and "N" , you can have something like this :
=IF(F3="N",10,IF(F3="Y",3,"Invalid Data"))
Note your formula had problems with the following :
1. Use of Y and N instead of "Y" and "N" ; checking for a text value is done by enclosing the text within double quotes
2. Use of additional parentheses.
Narayan