If statements in excel 2007

Hi,

Here is my condition:

IF B27<>0, F27=B27
IF C27<>0, F27= C27/(1-D)
IF B27<>0 AND C27<>0, F27 = B26 + C27/(1-D)


I have the below formula:
=IF(AND(B27<>0,C27<>0),C27/(1-D27)+B27)

But this only calculates if BOTH B27 and C27 have values. But if only one or the other has values, it returns as "False".

Would appreciate any help from this group.

Thanks,

Thank you Mr. benishiryo! It worked perfectly.

For sixthsense:

What I was trying to do was calculate the Selling Price (F27) based on Soft Cost (B27) and/or Hard Cost (D27). There will be occasions whereby I will only have values for Soft Cost, and sometimes only for Hard Cost, and sometimes for both. Thus:

IF B27<>0, F27=B27
IF C27<>0, F27= C27/(1-D)
IF B27<>0 AND C27<>0, F27 = B26 + C27/(1-D)

After calculating Selling Price, I then need to calculate my Profit on Hard Cost only (G27), which I have the formula as: (F27-C27)-B27. {This works, but would accept advice from this forum if I'm doing it wrong}

Hope this post will be helpful to others as well.

Cheers!

Thanks for the reminder, Vlady. If I may say, however--a little harsh on your tone

Anyways, actually it doesn't look like my formula to calculating the Profit based on Hard Cost is not working:

IF(AND(ISBLANK(B27)=TRUE, C27>0), F27-C27), IF(ISBLANK(B27)=FALSE), G27, “ “))

The conditions are:
IF B27>0 and C27=0, then G27 = 0
IF B27=0 and C27=0, then G27 = 0
IF B27=0 and C27>0, then G27 = F27-C27

So, if there is a value on B27 (Soft Cost) but nothing on C27 (Hard Cost), there shouldn't be no value on the G27 (Profit on Hard Cost). Alternatively, if there is no vale on B27 but there is value in C27, G27 should only be based on the value from Selling Price (F27) minus the Hard Cost. If there are no values on both Soft Cost and Hard Cost, there should not be values on Profit on Hard Cost.

Any help would be appreciated.

Thanks.