MrExcel.com - Your One Stop for Excel Tips & Solutions

Need help to build a very simple "IF" expression

Posted by Biny on December 01, 2000 8:47 AM

Hi everybody
I'm new to excel so don't be offended by my question OK?
I have spread sheet looks like this:
Cost1 Cost2 Total
1 2 3
2 0 0

On the “Total” column, I need help to build an expression that if Cost1 and Cost2 bigger than 0, then perform the sum on total If any of the Cost value is = or less than 0. Than the total will be equal 0. You can guy help me do that

Thank you very much

Biny

Posted by Baki on December 01, 2000 9:45 AM

Hi
Use this formula under the total column.
=IF(A2+B2<=0,"0",+A2+B2)

Good luck

Posted by Baki on December 01, 2000 9:54 AM

Hi again
If you want the total to be zero if any of the values under either cost1 or cost2 is zero or less, then use this formula:
=IF(OR(A2<=0,B2<=0),"0",+A2+B2)

Good luck.

Posted by Biny on December 01, 2000 10:48 AM

Thank you... what if...........................

Thank you very much for your help

But when I want to appy this expression for the whole column of "Total" so when I enter value on any cell of column "cost1" and cost 2. it will return a value on any cell on "Total" column.

thank you...