Fomula that will exclude blanks.

[gperez1127]

I am trying to create an IF formula as follows:
=IF(A1>0,b1>0,A1+B1, "")

So I want if to return anything above 0, and then add the two columns if there are numbers, but exclude blanks. I hope I am making sense. Not sure if the brackets are correct. Any help would be great.

 

[Scott T]

If you want "" returned if both are empty then

=IF(AND(A1>0,B1>0),A1+B1,"")

If you want to do A1+B1 as long as one of them is not blank then

=IF(OR(A1>0,B1>0),A1+B1,"")

 

[gperez1127]

thank you so very much for making it so simple.

 

[gperez1127]

Next question if possible in using this formula =IF(AND(A1>0,B1>0),A1+B1,"") how do I get it to not show #value !?

 

[Jonmo1]

Try changing A1+B1 to SUM(A1,B1)

 

[gperez1127]

Still getting value error

 

[Scott T]

what is in A1 and B1?

 

[JackDanIce]

Try:

=IF(AND(ISNUMBER(A1*B1),MEDIAN(A1,B1,0)>0),A1+B1,"")

 

[Jonmo1]

Try

=IFERROR(IF(AND(A1>0,B1>0),SUM(A1,B1),""),"")

 

[gperez1127]

This did it. thank you so much!