LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 81
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
use of ISERROR NathanG Excel Worksheet Functions 8 January 24th 07 06:31 PM
Iserror kelljeff Excel Discussion (Misc queries) 2 May 17th 06 03:02 PM
iserror Dauphin Excel Worksheet Functions 2 March 26th 06 11:46 PM
Iserror & VBA Ken G. Excel Discussion (Misc queries) 1 February 28th 06 11:37 PM
iserror Walshy Excel Discussion (Misc queries) 3 December 19th 04 05:13 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"