I have the following formula:
=IF(MIN(C5-D4,1-D4+G4,1-D4+G5,1-D5+G4,1-D5+G5,G5-H4)<0.5,"N","Y")

The problem is that if any of the referenced cells are blank, they are still included when the minimum is worked out, and I end up with the wrong result e.g. if D4 is blank, then the first calculation C5-D4 gives a negative number, and this could be the MIN value.

I either need something adding to the formula to ignore any calculations that include a blank cell, or some way to exclude any negative results for each calculated value.

Thanks for your help.

Catherine