pig

igpay

1. get first letter

2. find out if that letter is a vowel

3. if vowel, just give the word & "way"

4. else, take off the first letter, give rest of word, & first letter, & "ay"

=LEFT(B9, 1)

=OR(B10="A", B10="E", B10="I", B10="O", B10="U")

=B9&"way"

=MID(B9,2,1000)&B10&"ay"

=IF(B11, B12, B13)

  

40638

1. get the year

2. treat it like text

3. get len

4. substitute 0's for blanks, get len

5. subtract second len from first len

6. if 2 or more, say hooray. Else, say boo!

=YEAR(A18)

=TEXT(A27, "@")

=LEN(A27)

=LEN(SUBSTITUTE(A27, "0", "") )

=A29-A30

=IF(A31>=2, "hooray", "boo")