Excel formula not working right [Closed]

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,

I am trying to write a formula for the following situation and for some reason anything I come up with is not working properly:

if R2="Benefit Type X", AND D2="Group Name X","do not use the paragraph" all other groups would not use the sentence either it is a specific group and benefit type that would insert the sentence.

Any help would be greatly appreciated, using 2010

1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi Catfox,

I'm not sure if this is what you are looking for, if it's not, then please explain in greater detal.

=IF(AND(R2="Benefit Type X",D2="Group Name X"),"do not use the paragraph","")

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!