How to change formula

[cummingsea]

I have the following formula =IFERROR((IF(C19="","",C19+C5)),"") in a workbook in Excel 2007, but it will not work in Excel 2003, I know tha I have to use ISBLANK, I tried replacin the IFERROR with ISBLANK but that did not work. Said I had to manu arguments.

 

[barry houdini]

What sort of error do you expect? If C19 or C5 might be text perhaps just use

=IF(C19="","",SUM(C19,C5))

or for all eventualities

=IF(ISERROR(IF(C19="","",C19+C5)),"",IF(C19="","",C19+C5))

 

[cummingsea]

I used the second one and it works fine. Thanks A Million, Now if you can please help me with this one =IFERROR((IF(K6="","",K6)),"")

 

[cummingsea]

This appears to work =IF(C6="","",C6)