IF/OR Function

Originally Posted by NBVC

Try:

=IF(Countblank(H7:H8)=2,"",K7+H8-H7)

Thanks I changed it to this and it worked perfectly

=IF(COUNTBLANK(H7:I7)=2,"",K6-H7+I7)

I assume the countblank 2 mean if both cell are empty and if i was checking 3 cells I would change that to 3?

regards
Ian