Thank you so much. Worked perfectly!
"NHarkawat" wrote:
In cell C2 copy this formula
=if(and(A2="Yes",B2="No"),"yes","no")
then copy across col C
"Christine" wrote in message
...
New to this. Hopefully it's not too hard a question for someone out there.
I
can't seem to find my answer by searching here or on help.
Here's what I need to do: If the value in A2 is "Yes", and the value in
B2,
is "No", then C2 should become "Yes", else it should return "No". And I
want
this to calculate in column C thourghout the entire worksheet.
Here's where I'm at
=IF(B2="Yes",C2="No", D2= "Yes")
But it's not working correctly. Any help would be appreciated.
Thanks,
Christine
|