ISBLANK for 2 cells

[toony]

I need a blank result if cells bx and BZ are empty but don' t get it right. I have tried several ways in terms of parenthesis and just using a ISBLANK function instead of 2 but nothin seems to work and don't know what else to do. If you can help me please.

=IF(AND(ISBLANK(BX3)),(ISBLANK(BZ3)),"",BY3*CA3)))

 

[jtakw]

Hi,

Try:

=IF(AND(ISBLANK(BX3),ISBLANK(BZ3)),"",BY3*CA3)

OR, if you have formulas in BX3, BZ3, use:

=IF(AND(BX3="",BZ3=""),"",BY3*CA3)

 

[Phuoc]

Or try this

=IF(BX3&BZ3="","",BY3*CA3)

 

[toony]

Brilliant. Many thanks. I specially like the =IF(BX3&BZ3="","",BY3*CA3)
Though I think that i tried something similar and it wasn't working but that happened to me before with excel. You are set on one way and for whichever reason (format, etc) is not working. But you then try an alternative way and vuala, it miracusly works. Many thanks

 

[toony]

Hi Phuoc. Just to point out that I've tried your option with the ampersand (=IF(BX3&BZ3="","",BY3*CA3) .
Have tried it as below but it gives me an empty cell even if i put a number or string (tried both) in cell Y20.......any ideas why it would be?
=IF(W20&X20="","",Y20)

 

[Peter_SSs]

=IF(W20&X20="","",Y20)

That formula says that if W20 and X20 are both empty to put "" in whatever cell the formula is in. It doesn't matter what is in Y20 if both W20 and X20 are blank.
Put something in W20 or X20 or both and your formula will then return whatever is in Y20

 

[toony]

Ok, I see thanks. Very interesting (and shorter) to use the ampersand instead