adding to formula revised

[Crasher]

how can i add -(q10:q11) to the following formula with out returning #VALUE in cell N9, n9 is where this formula is

=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))))

i have tried adding the following to the formula -(q10:q11)

but does not work

please download my work sheet to see what i mean

q10 and q11 do have formulas in them.

[davesexcel]

My computer doesn't recognize the file format, save it as a regular .xls file then zip it

[Crasher]

i opened it ok

[oldchippy]

i opened it ok

Not everybody can open 2007 Excel files, especially if they have 2003

[Crasher]

hi oldchippy nice to here from you again.

is it possilbe that you can help me on this problem please.

this is the very last thing that needs to be done on this worksheet and then it is complete.

[Crasher]

can anyone help please

[Crasher]

this is such hard work

[Bryan Hessey]

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))


---

[Crasher]

just what the doctor ordered many thanks everyone

[Bryan Hessey]

just what the doctor ordered many thanks everyone

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

[mangesh_yadav]

Sorry, I was travelling and could not reply. Good to know your problem is solved.

Mangesh