+ Reply to Thread
Results 1 to 17 of 17

IF function with cells containing formulas

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    IF function with cells containing formulas

    Hi, can anyone help...

    I have an IF function showing pass or fail linked to two cells that each contain a formula to arrive at thier number, I am sure it is not too difficult, but I cannot figure this out.

    eg. =IF(B7>E7,"PASS",FAIL")


    when B7 contains: =E6
    and E7 contains: =E9

    please help, I can get this working ok if the referenced cells in the formula contain no formula themselves...
    Last edited by T. Grindlay; 02-04-2012 at 07:09 PM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    Ηι

    Try this.

    =IF(B7>E7,"pass","fail")
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

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

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    Hi,

    thank you for your assistance, I am going mad.... how does your formula differ from mine...

  4. #4
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    the formula works fine when I enter it in a new worksheet, but it does not seem to work in conjuntion with the workbook I am trying to create... frustrating...

  5. #5
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    I have attached the workbook, and deleted all the non relevant worksheets and data... maybe someone can have a look ? .. thanks

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    Hi

    I get an error in E1 & E3:E6.

    also E3 & B3 ARE EMPTIES!!

    What are you trying to do there???

  7. #7
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    Sorry, just the formula in E22, and relevant cells, the rest are in progress or disabled.... E22 should show pass or fail....... thanks : )

  8. #8
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    my first post using B7, E7, was just an example, before I post the worksheet,

    E22 should show pass, if the number achieved is greater than the number required, and vice versa, the related cells are linked back through the combo box to the data sheet... it seemed to me that the formula I was entering was showing that the alpha/numeric name of the cell was greater than the other cell, rather than the formula reading the equation result of the cell... is it because of the format of content of the cell ?? I dont know... I rerally am new to Excel, (although I am sure it is one of my favorites, if not my favorite... thanks if you can help with that formula...

  9. #9
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    Hi

    ..It's strange, but as i get many errors, i can not see where your formula comes from.

    In any case, take a look to the sample.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    Hi Fotis,

    yes I opened your sheet, and it was not working at all, but I just opened the sheet I uploaded, and the relevant links seem to work fine.

    Effectively, the 3 drop down boxes should alter the values shown in Cells E20 and E16.

    E22 should show "PASS" if E20 value is greater E16, or "FAIL" is E20 is not equal to or greater than E16.

    Could you try to down load again, the relevant formulas linked ok for me. Thanks.

  11. #11
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    ..No. Gives me errors..

    But anyway...Pls tell me, what you have in B13??

    =???

  12. #12
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    =IF(AND(C18=1),"5100",IF(AND(C18=2),"6700",IF(AND(C18=3),"4800",IF(AND(C18=4),"6100",IF(AND(C18=5),"13834",IF(AND(C18=6),"13200",IF(AND(C18=7),"8435",IF(AND(C18=8),"19250",IF(AND(C18=9),"27000",IF(AND(C18=10),"6090",IF(AND(C18=11),"7550",IF(AND(C18=12),"5550",IF(AND(C18=13),"4880",IF(AND(C18=14),"5650",IF(AND(C18=15),"7550")))))))))))))))


    the number 1 - 15 are linked to the gutter types on DATA 1, there are also cells behind two of the drop boxes (one has already been moved out of the way, revealing cells)

    It is strange, because when I download it, it does not have the same errors that I see in your workbook... ??? Thanks.

  13. #13
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    =IF(AND(C18=1),"5100",IF(AND(C18=2),"6700",IF(AND(C18=3),"4800",IF(AND(C18=4),"6100",IF(AND(C18=5)," 13834",IF(AND(C18=6),"13200",IF(AND(C18=7),"8435",IF(AND(C18=8),"19250",IF(AND(C18=9),"27000",IF(AND (C18=10),"6090",IF(AND(C18=11),"7550",IF(AND(C18=12),"5550",IF(AND(C18=13),"4880",IF(AND(C18=14),"56 50",IF(AND(C18=15),"7550")))))))))))))))
    I think, must be this...When you use numbers like this "5100", then Excel "things" that is Text, not Number..! Try without these""

    =IF(AND(C18=1),5100,IF(AND(C18=2),6700........

  14. #14
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    hmmm ... interesting .... thanks ...... I will give that a go now .....

  15. #15
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    ..Let me know....

  16. #16
    Registered User
    Join Date
    09-08-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: IF function with cells containing formulas

    Hi Fotis...

    thanks so much, that is fantastic, I removed the quotation marks, and I have tried a few combinations... seems to be working perfectly..... again... Thanks : )

  17. #17
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF function with cells containing formulas

    You are welcome!!

+ 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