Help with ISERROR
I did not test this, but you should be able to just add another IF statement
and check for errors:
=IF(ISERROR(IF(Scorecard!$B$4=Data!I18,IF(Data!N1 8=M18,MIN(Data!N18-M18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(AB18/Data!O18)-MIN(Data!N18-M18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18),MIN(Data!M18-N18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(-AB18/Data!O18)+MIN(Data!M18-N18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18)),0)),"-",IF(Scorecard!$B$4=Data!I18,IF(Data!N18=M18,MIN (Data!N18-M18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(AB18/Data!O18)-MIN(Data!N18-M18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18),MIN(Data!M18-N18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(-AB18/Data!O18)+MIN(Data!M18-N18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18)),0))
Laura
"juliejg1" wrote in message
...
I have the following formula in a cell which works correctly:
=IF(Scorecard!$B$4=Data!I18,IF(Data!N18=M18,MIN( Data!N18-M18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(AB18/Data!O18)-MIN(Data!N18-M18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18),MIN(Data!M18-N18,DAYS360(Data!I18,Scorecard!$B$4,FALSE))/30*(-AB18/Data!O18)+MIN(Data!M18-N18,MAX(DAYS360(Data!I18+O18*30,Scorecard!$B$4,FAL SE),0))/30*(AB18/Data!O18)),0)
I need to add an error check because I have getting #DIV/0 in blank cells.
I need it to check for error message and put "-" in those cells where an
error occurs. I have tried to add the ISERROR function to the formula but
must be doing it incorrectly because I can't get it to work. Any
suggestions?
|