If Statement to calculate profit

Hi,

I am calculating Gross Profit based on Hard Cost only. The conditions are:

1) If there is value in Soft Cost + Hard Cost, Profit is calculated based on Hard Cost only.
2) If there is value in Hard Cost only, Profit is calculated based on Hard Cost only.
2) If there is value in Soft Cost only, Profit is not calculated (ie. Profit is zero)

The formula I have is:

IF(AND(B26="",C26>0),F26-C26,0)

However, it does not work for scenario #1 above. What happens instead when there is a value for Soft Cost, the Profit is calculated as Zero.

I've attached a Scenario file here.

Would appreciate any help from this Forum.

Thank you.

I guess：

HTML Code: 

Hi,

Try This: IF(AND(B2=0,C2>0),E2-C2,IF(AND(B2>0,C2>0),E2-C2,0))

Is this what you are looking for?

Please Login or Register  to view this content.

Returns profit of 200 in scenario 1 & 2 with profit of 0 in scenario 3.

Thank you both Abaglas and Picassov7. They both worked. Only difference is in formatting of the results--somewhow, Mr. Picasso, you formula returns a "0" in the cell instead of blank when I select "Accounting" as format. But not a big deal.

Thank you again--appreciate it.