# IF formula with two cell conditions

1. ## 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?

2. ## Re: IF formula with two cell conditions

try this...

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

3. ## 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.

4. ## Re: IF formula with two cell conditions

Opps sorry, I left out an if

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

5. ## 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. ## 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. ## Re: IF formula with two cell conditions

happy to help and thanks for the feedback

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

#### 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