Another possibility
In C2 copied down
=IF(B29,A2 & ", " & B2,A2 & ", " & "0" & B2)

"Cam" wrote in message
...
Hello,

I am not sure how to use the formula or function that CONCATENATE two
fields
based on a IF function.
If the month field is 1 to 9, then add 0 before the month, then
concatenate
the year & month.
Example Data:
Year Month Concatenate Result
2007 3 2007, 03
2007 4 2007, 04
2008 12 2008, 12
2008 6 2008, 06
2009 10 2009, 10