IF (ISBLANK) checking more than one cell

HH_BE1894

I'm a beginner and trying to update this formula below to also produce a blank result if Reach@row is blank.

=IF(ISBLANK([Total Engmt]@row), " ", ([Total Engmt]@row / Reach@row))

Paul Newcome

Try this:

=IF([Total Engmt]@row <> "", IFERROR([Total Engmt]@row / Reach@row, ""))

Jess Bowles

=IF(ISBLANK([Total Engmt]@row) = TRUE (or FALSE, depending on what you want), " ", ([Total Engmt]@row / Reach@row))

This is the correct format for the formula!

HH_BE1894

This doesn't address if Reach is blank. The formula I have works to return a blank cell if Total Engmt is blank, but I also need it to return a blank cell if Reach is blank. As I have it now, I get an error "#DIVIDE BY ZERO" if Reach is blank.

Paul Newcome

Try this:

=IF([Total Engmt]@row <> "", IFERROR([Total Engmt]@row / Reach@row, ""))