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 at 0:35
  • You may want to fix == into =. – LWC Jan 25 at 22:42

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, privacy policy and cookie policy

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