Like Siddharth suggested I think your requirement can be easily fulfilled using calculated columns. To do this click on add column and select more then on the new screen select calculated. Rest is pretty basic stuff You can see the attached screenshot for more reference. Once you have done selecting all the settings click on OK.
and Viola you problem is solved :]
The new column would look something like this
Hope this helped somebody out there :]