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