Percentages & IF formula

[lec2012]

Hi

I was hoping someone could give me some help on the below query.....

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I hope this is explained a little better than my previous attempt:
<o></o>
Example One:<o></o>
<o></o>
Cell AK 8 = 95% (What percentage trained is the employee?)
Cell AL 8 = No (Has the person been with us less than 30days?)
<o></o>
Example Two:<o></o>
<o></o>
Cell AK 9 = 80% (What percentage trained is the employee?)
Cell AL 9 = Yes (Has the person been with us less than 30days?)
<o></o>
In column AN8 I would want the percentage in AK8 as the person has been with us for more than 30days (ie Column AN8 should be returned as 95%)
<o></o>
In column AN9 I would want the percentage to be discounted (or omitted / returned as zero) as the person has been with us less than 30days.

Any help would be greatly appreciated

 

[el_ja]

Would the days in cells AL8 or AL9 always be yes or no, or you would input the number of days?
If its gonna be yes or no try
=IF(AL8="Yes",AK8,0)
If its gonna be a number
=IF(AL8>=30,AK8,0)