a simple if function ?

[iffi]

confused, tried myself but faild
how do i combine 2 or 3 conditions to be met together at the same time.
example:
if A1 and B1 are not blank and A1 and B1 both are greater than 0 then do this A1 - B1

Thanks for ur co-operation as usual.

 

[xenou]

Maybe like this:

=IF(AND(A1>0,B1>0),A1-B1,FALSE)

What would you want the result to be if there was a number in a1 or b1 that was less than zero (not meeting your criteria). Or if both are blank?

 

[iffi]

Thanks ur quick and kind reply, i got my problem solved by ur given formulae.
u misunderstood some words in my post. i said above, if both are not blank that means they must contain some numbers and also they must be greater than zero, in this way, i will get my desired result. Thanks again

 

[FishingIsMoreFun]

Here is one I made, though I also may have misread the question.
It just checks for blank cells and checks if the value is >0.

=IF(AND(A1<>"",B1>0),IF(AND(B1<>"",B1>0),A1-B1,""),"")

cheers

 

[mmmarks]

=if(and(a1<>"",b1<>"",a1>0,b1>0),a1-b1,"")

 

[FishingIsMoreFun]

=if(and(a1<>"",b1<>"",a1>0,b1>0),a1-b1,"")

Interesting.
So the AND() function can have multiple conditions?

Cheers

 

[mmmarks]

Yes. we can test upto 255 logical conditions in AND() function.