I want a program in MS EXCEL 2007 where I could write the values in two different columns based on values in the arbitrarily selected other two column’s figures. For Example:
I want to track profit and loss for whole year, In column A I have profit (from Jan to Dec) and in column B I have expenses (from Jan to Dec). I want to put a condition where the figure could automatically listed in column C if the figure in column A is greater than column B and the figure could automatically listed in column D if the figure in column A is less than column B.
So basically a comparison where the text will go in column C if column A > column B and figure will go in column D if Column A < Column B.