Excel Formula help

Would =IF(B2=C2, "Y", "N") work?

It sounds like you need to do a double IF IYKWIM but i'm not sure that even exists !

All i can suggest is do 2 Ifs in sep columns to see if each is Y and then an if to see if they are the same, does that make sense ?

This isn't especially elegant, but try =IF(IF(B2="Y",1)+IF(C2="Y",1)=2,"Y","N")

That only says if they are the same not if they are both Y (ie they could both be N)

If you look in the help menu for a nested IF function, there's a lovely example there that you can cut and paste and change cell references / logic values to suit your needs

Sounds like you need the And argumentwhere you say And(this equals this, that equals that, etc, etc) So in this instance something along the lines of =IF(AND(B2='Y',C2='Y'),'Y','N')

Yup, that works too - and it's more elegant than mine.

Thank you folks. You'd never believe I've actually got a PGDip in Computer Science - I think all those years spent at 40,000ft and the added complication of pregnancy brain means that any logic I had has gone.