Results 1 to 20 of 20

IF Function Does Not Calculate Properly When Adding a 3rd IF formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-16-2014
    Location
    Riverside, IA
    MS-Off Ver
    2010
    Posts
    156

    IF Function Does Not Calculate Properly When Adding a 3rd IF formula

    Hello All,

    The following equation calculates the correct answer, 2264, where D11 = 175 , D10 = 13%:

    =IF('Data Input'!$D$9="Female","",((370+(21.6*'Data Input'!$D$11*1-$D$10))/2.2)*IF('Data Input'!$D$12="10 - 30",1.2))

    but the following modified equation does not calculate the correct answer, 1886 (it calculates 0, an incorrect answer), where D11 still = 175 and D10 still = 13%:

    =IF('Data Input'!$D$9="Female","",((370+(21.6*'Data Input'!$D$11*1-$D$10))/2.2)*IF('Data Input'!$D$12="0",1)*IF('Data Input'!$D$12="10 - 30",1.2))

    Thank you,

    Patrick
    Last edited by EverClever; 07-15-2017 at 10:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  2. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  3. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  4. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  5. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Replies: 2
    Last Post: 03-20-2009, 01:29 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