adding to formula revised

Originally Posted by Crasher

this is such hard work

not made any easier by the xlsx file, you need to 'saveAs' a standard file format if you want others to be able to read your file.

Your formula =IF(AND(ISBLANK(D9),ISBLANK(E9)),"",IF(24*(IF(E9>D 15,D15+2-E9,D15-E9))=0,24,24*(IF(E9>D15,D15+3-E9,D15-E9)))) seems to say, If E&D9 are blank then blank, else if *24 = 0 then 24, else 24*

If you want to subtract Q10:Q11 then why not either -Q10-Q11 or -Sum(Q10:Q11) to give

=IF(AND(ISBLANK(D9),ISBLANK(E9)),"",IF(24*(IF(E9>D 15,D15+2-E9,D15-E9))=0,24,24*(IF(E9>D15,D15+3-E9,D15-E9))-Q10-Q11))

or
=IF(AND(ISBLANK(D9),ISBLANK(E9)),"",IF(24*(IF(E9>D 15,D15+2-E9,D15-E9))=0,24,24*(IF(E9>D15,D15+3-E9,D15-E9))-Sum(Q10:Q11))


---

Originally Posted by Crasher

just what the doctor ordered many thanks everyone

Good to see your problem resolved, . . and thanks for the response