View Single Post
  #1   Report Post  
SCOOBYDOO
 
Posts: n/a
Default If function help

Hi

In col D2:D6585 I have 19 codes i.e. A, C, BS etc in col G2:G6585 I have age
attained. I need to work out the following:

If age 24 then output is "Ineligible"
If code < A or C and age =18 the output is "In FTE?"
If code = A or C and age = 21 the output is "In FTE?"

Many thanks