Yes or No formula

[geliedee]

Hi all,

i need a formula for this:

IF G6 = YSHP its should be YES
IF G6 = YGPY AND YPAY COLUMN J = COLUMN A IF NOT ELSE NO
AND IF G6 = YSTP THEN COLUMN J =COLUMN P IF NOT ELSE NO

Here's the formula i used: But i think its wrong:

Please Login or Register  to view this content.

[zbor]

It's unlcear from your description but try this:

Please Login or Register  to view this content.

[geliedee]

Hi Zbor,

How about if the column G6 = YSTP? Column J should be = Column P.

I tried the formula above, but for YSTP seems like its not working

[zbor]

Here:

Please Login or Register  to view this content.