+ Reply to Thread
Results 1 to 4 of 4

IF function not working when I make a ratio the then result

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    41

    IF function not working when I make a ratio the then result

    When I create an IF/THEN formula, it will not give me good results if I use a sum function / a number as the THEN result.

    This works:
    =IF(AND(C122=0,C125>=17,SUM(C125:C128)=21,C128=0),1,0)

    But this doesn't work:
    =IF(AND(C122=0,C125>=17,SUM(C125:C128)=21,C128=0),1,SUM(C123:C125)/21))

    I have attached my spreadsheet for your review. On row 140, the peach colored cell (E140) works. I need the blue cell (F140) to work. Your thoughts?ANDERSON Chemotherapy Orders and Independent Verification Audit Sheet WHAT.xlsx

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: IF function not working when I make a ratio the then result

    Hi,

    "I need the blue cell (F140) to work"

    What is "to work" in this case? What should the result be?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: IF function not working when I make a ratio the then result

    Looks to me like it's working...
    Coïncidentally, with these parameter values the outcome is always 1, regardless of the conditions in the "AND" part
    When I say semicolon, u say comma!

  4. #4
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: IF function not working when I make a ratio the then result

    If you want the results to be 0, like in your first formula, you should substract the 21, not divide by it (21-21=0 and 21/21=1...)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Custom Function for Thinness Ratio
    By mmart001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2011, 12:37 AM
  2. [SOLVED] Divide x/y should give Ratio x:y,How to express ratio in excel
    By arvind3738 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2006, 03:29 AM
  3. How to make the Result of a TODAY Function static?
    By kscramm in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-23-2006, 04:20 AM
  4. Ratio function
    By Lea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2006, 11:20 PM
  5. [SOLVED] How do I create a ratio function in Excel?
    By Michele in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2005, 01:06 PM

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