Hi all,

This is my first post in the forum, so please bear with me.

I am currently drafting financial statements in Excel 2007. The income statement has two columns, one for current year figures and one for prior year figures. I request assistance with the "Gross Profit/Loss" line description.

I want the description to change based on whether the figures indicate a profit or loss as follows:

Capture.PNG

Description, Current year figure, Prior year figure

Gross profit, Positive number, Positive number
Gross loss, Negative number, Negative number
Gross profit/loss, Positive number, Negative number
Gross loss/profit, Negative number, Positive number

So basically I need a formula for the description field to change based on the change in the figures as above.

Thanks very much