+ Reply to Thread
Results 1 to 3 of 3

getting #DIV/0! in my if( statement

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    12

    getting #DIV/0! in my if( statement

    new member please be gentle

    In short: I have an if statement that I would like to return "0" when it divides by 0 instead of "#DIV/0!"

    The formula is: =IF(T5/T10>V5,25%*W5,0)

    T5 = $Revenue
    T10 = No. of customers
    V5 = $revenue threshold
    W5 = $profit

    So If the average revenue (T5/T10) is greater than a certain number (V5) , take 25% of profit (W5), if we don't meet that threshold, show 0.

    I would like the formula to say If the average revenue is greater than a certain number, take 25% of profit, if we don't meet that threshold, show 0 AND if there are 0 customers show 0 instead of #DIV/0!.

    Any and all help is much appreciated. Than you

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: getting #DIV/0! in my if( statement

    =if(T10=0,0,IF(T5/T10>V5,25%*W5,0))

  3. #3
    Registered User
    Join Date
    05-03-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: getting #DIV/0! in my if( statement

    Thank you! So fast and helpful.

+ 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