I am trying to use the IF function to look at a range of cells and return a
true false value if any cell in that range is above certain number. i.e.
=IF(B7:E750000,100,0)
however, it is returning a false value if any of the cells in the range are
false not a true value if any are true, what am I missing? Thanks in advance
for any help.