How can I ignore or address blank cells in an Excel function?

Question

I have 7 columns and I want to check if each value in the columns are the same. However, each column does not have a value. I would like to create a function that says:

=IF("A = B = C = D = F = I = J", Value of the cells, False) However, I want to ignore any blank cells, so it does not trigger a False.

The actual ID column should populate to: False, 2, 3, 4, 5, 6, 7.

Why not just sum them? and compare to the final correct result? 1+2+3+4+5+6+7 = 28 — Solar Mike

Josh Josh · Accepted Answer · 2019-05-16T14:46:02

2

votes

I got an answer. I am using =if(max(range) = min(range), max(range), FALSE)

This works!

How can I ignore or address blank cells in an Excel function?

2 Answers