If you are more of a visual person and would like to organize your folders and files using different colors, than check it out how to use color labels in Mac OS X.
I'll show you the basic usage of IF function in Google Drive Spreadsheet. The IF function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.