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)))
=IF(AND(ISBLANK(BX3)),(ISBLANK(BZ3)),"",BY3*CA3)))