+ Reply to Thread
Results 1 to 7 of 7

IF formula with two cell conditions

  1. #1
    Registered User
    Join Date
    07-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    66

    IF formula with two cell conditions

    Dear All,

    Need your help regarding below condition.

    I need to drive out a formula as below:

    If in cell P93 I enter any number (greater than ZERO) and in cell T93 if the answer is coming YES then in cell Y93 I need answer as 1

    If in cell P93 I do not enter any number and in cell T93 YES is appearing then I need answer in cell Y93 as 0 (zero).

    Can you please help me with that? I'm not sure VLOOKUP will apply here or IF formula?

    Thanks a ton in advance!!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: IF formula with two cell conditions

    try this...

    =if(T93="yes",P93>0,1,0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: IF formula with two cell conditions

    Thank you Sir for your kind and quick reply, but it says you have entered too many arguments for this function.

    Can you please help again?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: IF formula with two cell conditions

    Opps sorry, I left out an if

    =if(T93="yes",if(P93>0,1,0),"")

  5. #5
    Registered User
    Join Date
    07-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: IF formula with two cell conditions

    Dear its still not working

    I'll put my question again for your review.....

    If cell P93 contains an integer 1, 2, 3 or any number greater than ZERO and T93 contains YES then in Y93 I need an answer 1.

    If cell P93 is empty and T93 contains YES then I need answer in Y93 as 0 (zero).

    I need function which is dependent on P93, if P93 contains any value then only T93 should be taken in consideration otherwise answer should remain as ZERO.

  6. #6
    Registered User
    Join Date
    07-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: IF formula with two cell conditions

    MY MISTAKE SIR!!! :$ :$ :$ :$ :$


    I didn't saw I was applying in the wrong cell Sorry for troubling you!!!

    Thanks once again!!!! :D

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: IF formula with two cell conditions

    happy to help and thanks for the feedback

+ 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. Formula to add 1 to a cell value or leave the same if conditions not met
    By batjl9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2012, 09:50 AM
  2. Replies: 2
    Last Post: 04-14-2011, 08:12 PM
  3. Formula help with multiple cell conditions
    By tvwhome in forum Excel General
    Replies: 4
    Last Post: 01-16-2011, 01:26 PM
  4. Replies: 3
    Last Post: 03-23-2010, 06:50 PM
  5. [SOLVED] Formula that will test text conditions in a single cell
    By Prohock in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-04-2006, 05:25 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