Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with ISERROR
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of ISERROR | Excel Worksheet Functions | |||
Iserror | Excel Discussion (Misc queries) | |||
iserror | Excel Worksheet Functions | |||
Iserror & VBA | Excel Discussion (Misc queries) | |||
iserror | Excel Discussion (Misc queries) |