Need to perform operation if multiple cells are blank or nonblank

[jonservet]

Hi All,
I'm new to this forum (just registered today) as I've seen many good problems/solutions posted. I'm a relatively new user of excel formulas and need help with this particular condition:
I'm trying to tell excel to return the product of 2 cells (A and B) depending on these conditions:
If cell C is blank, display blank
and if cell C is not blank, but cell D is blank, then return A*B
and if cell C is not blank, and cell D is not blank, then displace blank
-All within the same cell

So far I've tried multiple options with IF formulas, but I have only gotten to get this one working correctly:
=IF(ISBLANK(J29),"",F29*B29)

Any help or guidance anyone could provide would be greatly appreciated

Jon

[BadlySpelledBuoy]

Of the three scenarios you mention, only one of them will result in anything other than blank. So, in theory, the formula below should work for you.
Adjust row numbers to suit.

Please Login or Register  to view this content.

BSB