Formula with multiple IF's?

[ciapul12]

Hi There,
I need to do a simple calculation between 2 cells in a table.
Column headers are "Weight in" and "Weight out" I simply need to deduct weight out from weight in and only want this calculation to be applied when both cells contain value and weight out is less than weight in .

Thanks
Dan

 

[Joe4]

Let's say that "weight in" is in cell A2 and "weight out" is in cell B2.
Then the formula might look like:

=IF(AND(A2<>0,B2<>0,A2>B2),A2-B2,"")