I have 4 empty cells, and a formula in 4 other cells that show data from those cells. The formulas look like this -

=IF(B5 > C5, B5, C5)
=IF(B5 > C5, C5, B5)

==IF(B7 > C7, B7, C7)
=IF(B7 > C7, C7, B7)

The original 4 cells are all blank, and the type is all set to automatic. But the ones in row 5 show as 0s, and the ones in row 7 show blank. I want them to be blank until I put values in the original cells.

How can I change it so the values in row 5 return blank instead of 0s?

  • Welcome. Suggest you clear formatting (Format> Clear Formatting) on cells B5, C5, B7 and C7, and then see what the results look like. My own tests return all blanks.
    – Tedinoz
    Jan 17, 2021 at 0:35
  • You may want to fix == into =.
    – LWC
    Jan 25, 2021 at 22:42

1 Answer 1


I believe you want the following:

=if(or(isblank(B5), isblank(C5)), "", IF(B5 > C5, B5, C5))
=if(or(isblank(B5), isblank(C5)), "", IF(B5 > C5, C5, B5))

=if(or(isblank(B7), isblank(C7)), "", IF(B7 > C7, B7, C7))
=if(or(isblank(B7), isblank(C7)), "", IF(B7 > C7, C7, B7))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.