IF formula with two cell conditions

[MYEM1983]

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

[FDibbins]

try this...

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

[MYEM1983]

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?

[FDibbins]

Opps sorry, I left out an if

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

[MYEM1983]

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.

[MYEM1983]

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


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

Thanks once again!!!! :D

[FDibbins]

happy to help and thanks for the feedback