+ Reply to Thread
Results 1 to 3 of 3

Fixing a Formula

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Grand Rapids, MI
    MS-Off Ver
    Excel 2010
    Posts
    24

    Fixing a Formula

    I need the formula in the B:C cells to display values that are negative from the second tab. I got it started, but I'm not sure where I'm going wrong. I don't want it to display the #value! errors.

    Commission Sheet 051713.xlsx

  2. #2
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Fixing a Formula

    try to put error trapping, IFERROR()
    =IFERROR(IF(MonthSel="","",IF(OR($E$1="",ROWS(B$5:F5)>COUNTIF(INDEX('Monthly Formulas'!$B$28:$M$34,0,MATCH($E$1,'Monthly Formulas'!$B$1:$M$1,0)),"<>0")),"",INDEX('Monthly Formulas'!$A$28:$A$34,-SMALL(INDEX((INDEX('Monthly Formulas'!$B$28:$M$34,0,MATCH($E$1,'Monthly Formulas'!$B$1:$M$1,0))<>0)*(-ROW('Monthly Formulas'!$B$28:$M$34)+ROW('Monthly Formulas'!$B$28:$M$28)-1),),ROW(A1))))),"")

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    Grand Rapids, MI
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Fixing a Formula

    Awesome, that works, thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1